>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.

Why not use Xbase ?
Like

Create cursor tempinward1(.....)
select inward1
Set order to tag recol
seek m.lxreco1
scan rest while reco1=lxreco1
insert into tempinward1 values(...)
endscan