The SET ENGINEBEHAVIOR 70 does not solve problems with GROUP BY been invalid but rather hides them.

>Have you tried SET ENGINEBEHAVIOR 70? This has so far solved all of my problems with VFP7 queries that had the invalid group by error when run in VFP 9.
>