Dear Experts
I am planing to convert my Projects from VFP6 to VFP9.
Following command is written in VFP6 and work fine but when I run it into VFP9,
it show following error message
SQL:GROUP BY Clause is missing or invalid
What should I do get rid of this error message.
Please help
SELECT *,;
SUM(IIF(Mode="B",BAGS,0))AS BAGS,;
SUM(IIF(Mode="L",BAGS,0))AS LOSE,;
SUM(WEIGHT) AS unfix_kg,;
SUM(W_KG) AS unfix_a;
WHERE BETWEEN(DATE,F_DATE1,T_DATE1);
FRoM AVLBOOK;
ORDER BY ACC_CODE;
GROUP BY ACC_CODE;
INTO CURSOR XYZ