Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Limit number of ANDs in a logical expression
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Versions des environnements
Visual FoxPro:
VFP 7 SP1
Database:
Visual FoxPro
Divers
Thread ID:
01095106
Message ID:
01095119
Vues:
11
Terry,

There is a limit on the string length. But it should not give you the syntax error.

At least this works for 1000 "and"s:
CLEAR
ll="hi = .t."
FOR ia=1 TO 1022
	ll= ll +" and .t."
ENDFOR
?LEN(ll)
&ll
?hi
>Is there a limit on the number of AND conditions in a logical expr. I use the code below. It was operating fine till I I had to add another 6 conditions. Now the compiler highlights whole lot and just says "syntax error". I enclose the code just in case any of you dead-eye Dicks can see a typo or whatever (it all colour codes OK in the editor)
>
>While I'm at it, anyone know whether if any of the conds. fails it will not bother assessing the rest, as I suspect?
>
>'ppreciate it.
>
>Terry
>
>
>With Thisform
>  llOpenedEnough	= .lmGetMIFacMast( lcMapDataPath) and ;
>  		  .lmGetMIZG( lcMapDataPath) and ;
>  		  .lmGetMIRZStops( lcMapDataPath) and ;
>  		  .lmGetMIStops( lcMapDataPath) and ;
>  		  .lmGetMIRoutes( lcMapDataPath) and ;
>  		  .lmGetMIJourneys( lcMapDataPath) and ;
>  		  .lmGetMIOperators( lcMapDataPath) and ;
>  		  .lmGetMITendTypes lcMapDataPath) and ;
>  		  .lmGetMIServCats( lcMapDataPath) and ;
>  		  .lmGetMIOpQuals( lcMapDataPath) and ;
>  		  .lmGetMIVehTypes( lcMapDataPath) and ;
>  		  .lmGetMIBooking( lcMapDataPath) and ;
>  		  .lmGetMITimeBand( lcMapDataPath) and ;
>  		  .lmGetMIOnDS( lcMapDataPath) and ;
>  		  .lmGetMIFacTypes( lcMapDataPath) and ;
>  		  .lmGetMIRESUS( lcMapDataPath) and ;
>  	           .lmGetMIAPs( lcMapDataPath) and ;
>  		  .lmGetMIAAs( lcMapDataPath) and ;
>  		  .lmGetMISysOpts( lcMapDataPath)
>EndWith
>
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform