>>>>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?
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham