Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
SQL command too complex - what should I do?
Message
De
10/12/1999 15:50:14
Michael Dougherty
Progressive Business Publications
Malvern, Pennsylvanie, États-Unis
 
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Problèmes
Divers
Thread ID:
00301958
Message ID:
00301987
Vues:
26
>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:
2) How can I resolve this situation? Do I need to calculate length of my macro string, finding space, etc. Would be a real PITA :(

Could you limit the selections in the multilist? (if normal use says 3-4 choices is adequate, 15 kills your code, limit the picklist to 10 at a time)

Assuming your macro is something like: Select ... Where ¯ostring,
Maybe you could do: Select ... Where value1 In Select value2 where value3=.T.
(value1=keyvalue, value2=picked value, value3=value2 was picked or not)

Or maybe I/we don't have enough info on what you're trying to do?
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform