>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.
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.