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?