>>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.
>>
>>Barb
>
>Believe me,
>That didn't solve anything.
>That just run wrong queries and you get something as result.
>But what if you want to move to some less forgivable database like SQL Server, Oracle or MySQL?
>
>Then you are in trouble.
>VFP team add this statement for easy convert from VFP7 to VFP8 or VFP9, so you can have time to fix your queries.

Exactly.