I have a prb on the accessing db2 by foxpro
HERE is my code
CREATE SQL VIEW grnviewtemp CONNECTION myConn as ;
SELECT GDGRNN, GDCRWS, GDPROD, GDPORD, GDVEND, GDRCQT, GDCRDT, GDSADN ;
FROM HGDL01 WHERE GDGRNN< testno ORDER BY GDGRNN
U can c testno which is a variable storing 30, but I cannot access the database. It throws error SQL0206
How can I solve it?