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.
It's a "flying quotes" :) Include it in the fun document :)
If it's not broken, fix it until it is.
My Blog