hi,
i hope this simple code help you, if i understand what you need.

CLOSE all
SET DELETED ON
use mytable in 0
SCAN FOR ID<>"101-1"
DELETE
ENDSCAN
brow

>i want to update and revert some records.
>
>my records as below
>

>
>
> Code      ID           Name        Record No.
>
> 101     101-1          mk          -1   && buffered new record
> 101     101-1          ms          -2   && buffered new record
> 101     101-2          mm          -3   && buffered new record
> 101     101-1          mr          501  && buffered old record
> 101     101-2          mx          550  && buffered old record
>
>

>
>
>i want to save the records, only have ID="101-1"
>
>i want to revert OR delete records that not have ID="101-1"
>
>warm regards,
>mk.