>>>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? :-)
>
>Actually this code is from a commercial 3P tool that is no longer supported. So I have to make some changes to make it work on VFP 9.
How the (.cCursor) clause worked in VFP6, as you stated in another message, when WITH..ENDWITH didn't exist at that time?
Why do programs stop working correctly as soon as you leave the Fox?