can you send a stored procedure a string array 1

[samantha72]

I have a list box in visual basic which will contain a max of 7 strings. I need to
save this data so i am thinking about looping through the list box and saving these
strings in an array but i am not sure if i can append the string array as a parameter and send it to the stored procedure.


each one of these strings in the array has a number associated with it and i have to
return the min of these numbers

If i can send the array then will the store procedure be able to loop through the array
to find the min number associated with these strings.

Thanks

 

[Tim1]

Hi Samantha,

In a word, no, Sybase won't be happy if you pass the information to it that way.

What you could do is put the information into a temporary table, from which Sybase could then select the minimum value.

The basic problem is that Sybase does not recognise arrays, so you need to send the data in a form that it can understand.

HTH

Tim