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
13/07/2006 20:53:50
Ian Johnston
Computer Software Solutions
Woodland, California, United States
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Group by clause is missing or invalid - but it is not!!
Miscellaneous
Thread ID:
01136284
Message ID:
01136284
Views:
61
I am running VFP 9.0 with SP1 installed, I cannot make a select work when using the group by, the following code gives the message "Group by clause is missing or invalid "

SELECT daily.DATE , daily.DELIV_TO , daily.DRY , daily.FIELD_TAG ,; daily.GROSS , daily.PKCOMMOD , daily.PKCOMPLOC , daily.PKCUSTOMER ,; daily.PKLOT , daily.SH_RE ;
FROM witsvfp9!daily GROUP BY daily.pklot
Next
Reply
Map
View

Click here to load this message in the networking platform