>>>It's invalid query because "MyTable.MyField" isn't either aggregate function nor it's included in the GROUP BY.
>>>
>>
>>I changed the SQL Select, making Group By "1,2" (instead of just 2) and it works now.
>>
>
>Than you can change
having not empty(&lcExpr)
>* to
>WHERE not empty(&lcExpr)
>
I think you are saying that by changing from Having to Where, the SQL Select will run faster, right? Why, then, the original programmer didn't use Where in the first place? That is, I am concerned that there might be another reason he had "Having" instead of Where and I don't want to break it. Unless you think he was just drinking tequila when writing this code <g>
"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