>
>This is the way, but it open THIS ISSUE: "the first fieldname is undefined":
>
>select MAX(&lcExpr), ;
> upper(&lcExpr) ;
> from (tcAlias) ;
> where not deleted() ;
> &lcFilter ;
> group by 2 ;
> having not empty(&lcExpr) ;
> into cursor (.cCursor)
>
I can see how adding MAX() would solve the problem with the SQL: Having clause. But what do you mean by the "THIS ISSUE"?
"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