i already have a TAG on DELETED() .

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

above command giving error :

command contains unrecognized phrase/keyword

if i use like below this working perfect but Partial Optimized.

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

SELECT qty,amt,plusminamt,Scheme,tdamt,cdamt,excise,taxamt,vatamt,octroi,freight,cnamt,Add,less,tbamt ;
FROM inward1 WHERE reco1=lxreco1 INTO CURSOR tempinward1

above Select Sql is Full Optmized.

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

above Select Sql is Partial Optmized.

Difference is Only :

WITH (BUFFERING = .T.)

warm regards,
mk.