Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Group by clause is missing or invalid - but it is not!!
Message
From
14/07/2006 11:10:47
Craig Berntson
Quicken Loans
Salt Lake City, Utah, United States
 
 
To
14/07/2006 01:00:30
Ian Johnston
Computer Software Solutions
Woodland, California, United States
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Re: Group by clause is missing or invalid - but it is not!!
Miscellaneous
Thread ID:
01136284
Message ID:
01136420
Views:
17
The reason for the change is that just using a single column can cause incorrect results. The new way is standards compliant.

>Yikes! I am moving a vfp7.0 app to 9.0, it use sum and group by in a lot of routines. Do you have to group by on all the columns ?
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform