Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
PHDBase problem with long WHERE clause
Message
From
14/08/1997 01:27:46
 
 
To
13/08/1997 21:15:39
General information
Forum:
Visual FoxPro
Category:
Third party products
Miscellaneous
Thread ID:
00044572
Message ID:
00044573
Views:
29
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?
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform