>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.
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.