Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Invalid Group By
Message
 
To
18/11/2009 13:23:33
Barbara Hill
B.L. Hill Applications Limited
Halifax, Nova Scotia, Canada
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows XP SP2
Database:
Visual FoxPro
Application:
Desktop
Miscellaneous
Thread ID:
01435336
Message ID:
01435429
Views:
53
>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.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform