>>>>>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?
>
>Jaime,
>
>Sorry I missed your reply to my reply (that is why delay in replying to you). But where do you see WITH..ENDWITH in my code?

Your reference to ".cCursor" can only be an object reference from an assumed WITH object reference. Unless it's a typo.