Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Group by clause
Message
 
To
09/11/2005 15:42:18
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Miscellaneous
Thread ID:
01066947
Message ID:
01066952
Views:
21
>Hello,
>
>In Northwind database for orderdetails table:
>
>SELECT orderid,productid,quantity as quantity FROM orderdetails GROUP BY productid ORDER BY productid,orderid
>
>Why always give an error ?
>
>SQL: group by clause missing or invalid
>
>TIA

The changes occured in VFP8. See mskb #813361 for details.
_______________________________________________________________
Testing displays the presence, not the absence of bugs.
If a software application has to be designed, it has to be designed correctly!
_______________________________________________________________
Vladimir Zografski
Systems Analyst
Previous
Reply
Map
View

Click here to load this message in the networking platform