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
May all your weeds be wildflowers