Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
What is wrong with this Having clause?
Message
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 9
Miscellaneous
Thread ID:
01062374
Message ID:
01062392
Views:
13
>>It's invalid query because "MyTable.MyField" isn't either aggregate function nor it's included in the GROUP BY.
>>
>
>I changed the SQL Select, making Group By "1,2" (instead of just 2) and it works now.
>

Than you can change
having not empty(&lcExpr)
* to
WHERE not empty(&lcExpr)
--sb--
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform