>>You have to group on all fields behind '*' and any of them cannot be Memo or Blob
>>
>
>same error
>
>

>SELECT  SUM(qty) as tot_qty, SUM(tot) as sumt, client, codesy, qty, unit, tot, comiss;
>		FROM cur_products;
>	GROUP BY codesy;
>	ORDER BY sumt  desc, tot_qty, desc;
>		INTO cursor cur_prod_tot
>

>
>

Once again, you have to group on all none-aggregate fields

SELECT  SUM(qty) as tot_qty, SUM(tot) as sumt, client, codesy, unit, comiss;
... 
GROUP BY client, codesy, unit, comiss ;

* if grouping on codesy only

SELECT  SUM(qty) as tot_qty, SUM(tot) as sumt, codesy ;
... 
GROUP BY codesy ;