It's all documented. RTFM!!!!

Look at the What's New section of the VFP help file for both VFP 8 and 9.

>Hi
>
>I am encountering "GROUP BY clause is missing or Invalid" errors using VFP9 (haven't tried VFP 8) in the following code.
>
>

>SELECT cnt(wo_itemno) as items, i_key, t_key, contractor ;
>	FROM v_woitems ;
>	INTO CURSOR tWoinvcont ;
>	ORDER BY t_key ;
>	GROUP BY t_key
>

>
>If I "SET ENGINEBEHAVIOR 70" the problem disappears.
>
>The same occurs when I create a query using the default SET ENGINEBEHAVIOR 90. It appears that this may be because I am doing a select on a view.
>
>Could someone point me to where I can find what has changed and how I create the same cursor using
>SET ENGINEBEHAVIOR 90.
>
>Regards
>Geoff Scott