>I've used the GROUP BY clause thousands of times. Now, all of a sudden in VFP 8.0, I'm getting an error message (Group by clause is missing or invalid) on a simple SQL statement:
>
>SELECT item, vendno, mfgbc ;
> FROM icsupl ;
> WHERE item = "9999-99-99" ;
> GROUP BY 2 ;
> INTO CURSOR xxxxx
>
>...will someone tell me what's going on.
>
Joel,
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.
--sb--