It's documented in VFP8 help under Behavior Changes Since Visual FoxPro 7.0 and in INFO: SQL SELECT Behavior Changes in Visual FoxPro 8.0 mskb #813361.


>
>I used GROUP BY command in an SQL statement to SUM UP a certain information:
>
>SELECT b.empno, b.start, b.end,;
>SUM(b.regpay) AS vregpay, SUM(b.otpay) AS votpay;
>FROM Paysumm b WHERE b.period2=CTOD('02/15/2004') GROUP BY b.empno
>
>The code above works perfectly on VFP 6 and 7. However, when I tried executing it on VFP 8, it gave a "SQL: Group By Clause is missing or invalid" error!?
>