Hi,
try
SET ENGINEBEHAVIOR 70

>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