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:
01062377
Views:
15
>I get error 1803: SQL: Having clause is invalid in the following SQL Select:
>
>
>select &lcExpr, ;
>   upper(&lcExpr) ;
>   from (tcAlias) ;
>   where not deleted() ;
>   &lcFilter ;
>   group by 2 ;
>   having not empty(&lcExpr) ;
>   into cursor (.cCursor)
>
>
>Can someone, please, point to me on what is wrong with the above expression?
>
>Thank you.

Geez you like macro expansion don't you? :-)
Why do programs stop working correctly as soon as you leave the Fox?
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform