Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
SQL command too complex - what should I do?
Message
 
 
À
10/12/1999 19:38:53
Information générale
Forum:
Visual FoxPro
Catégorie:
Problèmes
Divers
Thread ID:
00301958
Message ID:
00302108
Vues:
41
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
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform