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