Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
SQL command too complex - what should I do?
Message
 
 
À
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:
00302045
Vues:
30
Michael,

>>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?

I gave a little more info in my answer to Mark. Yes, we would restrict the user's choice. Even if I don't like it, because, I'm afraid, it's an only chance. I'll also take a look into SYS(3055) as John and Ed advised, may be it would help me, but I doubt.
If it's not broken, fix it until it is.


My Blog
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform