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?