hi,
thank you very much,

i need to delete all records form nan.dbf and REPLACE all data from xldata.NOT APPEND.

CLOSE all
USE xldata in 0
USE nan in 0
   Blank FIELDS EXCEPT column19&& delete all data for all fields except column19 and go top of nan.dbf

select xldata 
SCAN
   SCATTER memvar 
   *!* either append blank or seek correct record to update
   SELECT NAN
   append blank
   && i need to replace (delete all data replace new data)
   GATHER memvar field EXCEPT column19
   
ENDSCAN

thanks.
m.qasem