>Hello at alls...
>
>I have an aplication runnig on my pc without any trouble; but in other one the aplication return this error the GROUP BY sentence not exist or is invalid.
>
>I wonder if some body could tell me why the application make this error if this one work correctly on my pc?
>
>TIA.
Check SET ENGINEBEHAVIOR in help. And by the way, FIX your queries, consider SET ENGINEBEHAVIOR 80 as a band aid temporarily. SET ENGINEBEHAVIOR 90 is how the queries always should have run, but earlier versions allowed not standard syntax which you should avoid.