how i can optimize :

WITH (BUFFERING = .T.)

if i use select - Sql as below, this is optimization level : Partial

local mymemvar
=sys(3054,11,"mymemvar")
SELECT qty,amt,plusminamt,Scheme,tdamt,cdamt,excise,taxamt,vatamt,octroi,freight,cnamt,Add,less,tbamt ;
FROM inward1 with (buffering = .T.) WHERE reco1=lxreco1 INTO CURSOR tempinward1
WAIT WINDOW mymemvar

if i use select - Sql as below, this is optimization level : Full
but not sum the buffered records.

but i want to Sum buffered records also.

local mymemvar
=sys(3054,11,"mymemvar")
SELECT qty,amt,plusminamt,Scheme,tdamt,cdamt,excise,taxamt,vatamt,octroi,freight,cnamt,Add,less,tbamt ;
FROM inward1 wHERE reco1=lxreco1 INTO CURSOR tempinward1
WAIT WINDOW mymemvar

warm regards,
mk.