Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
PHDBase problem with long WHERE clause
Message
De
14/08/1997 01:27:46
 
 
À
13/08/1997 21:15:39
Information générale
Forum:
Visual FoxPro
Catégorie:
Produits tierce partie
Divers
Thread ID:
00044572
Message ID:
00044573
Vues:
33
The parameter is 266 long. So, it seems to be a problem with more than 255-256 characters.

Try breaking into 2 strings. This works for EVALUATE(). (like "aaa"+"aaa" instead of "aaaaaa")

Vlad

>I have a small problem with PHDBase.
>
>I have found that I can't pass long string in the sense that in my VFP where clause, there seems to be a limit.
>
>I am having presently an error which says "Command contains unrecognized phrase/keyword". If I remove some conditions, it works.
>
>For example, this won't work:
>
>=PHD('FROM CLASSIFI WHERE <"VISUAL BASIC"> AND NOCLIENT=5 AND;
> ((TYPE=1 AND DATE<=DATE() AND DATEFIN>=DATE()) OR TYPE=6 OR;
> (TYPE=6) OR (TYPE=7 AND (DATE=CTOD(" / / ") OR DATEFIN>=DATE())) OR (TYPE=8 AND DATE<=DATE() AND DATEFIN>=DATE())) AND CANCEL=0 INTO HITS CURSOR TEMP')
>
>But, I have remove at least one condition, it will.
>
>Anyone have found a workaround for this?
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform