>Hi.. the error message says that I have an "invalid group by error".. My blind mind is not geting what should wrong down there.. Please, help me!!
>
>

>SELECT  *, SUM(qty) as tot_qty, SUM(tot) as sumt;
>		FROM cur_products;
>	GROUP BY codesy ORDER BY sumt desc, tot_qty, desc;
>		INTO cursor cur_prods_tot
>

>
>TIA
>
>Claudio

Claudio,
Read carefully whole SET ENGINEBEHAVIOR topic in the HELP.
You would see why you got that error.
I strongly recommend you to change all your queries to match that behavior. Not all at once of cource but one by one. Just set ENGINEBEHAVIOR to 70 in your main program, but you MUST change them.