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 tempinward1above command giving error :
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 tempinward1above 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 tempinward1above Select Sql is Partial Optmized.
WITH (BUFFERING = .T.)warm regards,