Ed,
>>>Again, putting the values into a cursor and using an IN (
subquery) may help with some of the length issues. There's no limit on the number of records in a subquery AFAIK.
>>
>
>Either that, or adding code to what you emit to convert your INLIST string into values used to populate a cursor, You aren't limited to what can be done in the scope of a single command - you can emit a fairly complex procedure, using conditionals, loops, or whatever else is needed to set up for the query, or massage the results before returning.
Ok, I've changed my btcc_multilist to use advantage of cursor. Works fine.
Thanks again for your ideas.
If it's not broken, fix it until it is.
My Blog