>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?