Are parameter arrays possible in XSDs?

[B. Chernick]

(This is, in a way, related to a previous post.)

When defining a procedure in VB, it is possible to pass an array of variable
length to it, and then parse it for content.

Is there any way to do something similar in an XSD query created in Visual
Studio 2005? What I need to do is pass a list of uncertain length to the IN
clause of an XSD query. i.e. Select * from table1 where key1 IN (list)

(Judging from what I've read so far, this appears impossible but I thought
I'd give this forum one last try. I suppose I could use a stored procedure
but I'm not sure I want to go that route.)

 

[Cor Ligthert[MVP]]

B,

AFAIK is it impossible to sent a list as parameters or whatever field to a
database server.

Cor

 

[B. Chernick]

Thanks. It does look like it's impossible.

In any case, while this is all very interesting, I have been able to
redesign the program using more conventional SQL calls.