>Ed,
>>>>>Just now I got this error message. I know why it happened, it's because I choose lot's of items in multilist, which affect on Init method one of my other controls. I think, it's VFP limitation 255 char on the macro string. So, my questions are:
>>
>>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.
>
> You're right, of course, but again, it would requir too much changes in our classes :( Ok, I'll discuss this with my collegues, and perhaps, we will change it this way. Very pity, that we're waisting our time and money, to design and redesign :(((
>
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.
> Thanks for all these ideas. They will not let me to sleep well this weekend :)
Sleep is not in your job description.