Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SQL error from VFP6 to VFP9
Message
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
SQL error from VFP6 to VFP9
Miscellaneous
Thread ID:
01000858
Message ID:
01000858
Views:
68
SELECT colltemp.*,COUNT(ctemp_name) AS r_count FROM colltemp ;
HAVING r_count > 0 GROUP BY ctemp_name INTO CURSOR tmpQuery

Went from VFP6 to VFP9 and now I am getting "Group by clause is invalid or missing"

Anyone know what is wrong?

Brenda
Next
Reply
Map
View

Click here to load this message in the networking platform