Thank you Ken, I will keep this as a last resort.
I would have to change a lot in my program because the clauses are generated on the fly from parameters, the enduser enters. I would be forced to change the function to support a new option to switch enginebehavior. So I try to circumvent that when possible.
Thanks
Gerhard
>>Hello,
>>
>>I have a SQL Select that does not work. I get "Missing or illegal GROU BY Clause".
>>
>> SELECT F1, F2, F3, F4, F5 ;
>> FROM TAB1 ;
>> INTO TAB2 ;
>> ORDER BY F1, F2, F3, F4 ;
>> GROUP BY F1, F2, F3, F4
>>
>>F5 is a memofield. So I can not include it in the GROUP BY.
>>How can I have the result grouped by the rest of the fields?
>>
>>TIA
>>Gerhard
>Hi Gerhard,
>
>Try SET ENGINEBEHAVIOR 70
>
>Hope this helps,
>
>Ken
Gerhard Schmidbauer
URANUS Software GmbH