Check to be sure that you are on the correct record in xldata and that xldata has fields of the same name as those in NAN.

If you are trying to replace field contents in NAN, be sure that you are on the correct record in NAN. The append blank was only because you were getting an EOF error message when you executed gather memvar.

If the above conditions are true, you should get all fields except char28 to match those in xxldata unless the fields you are trying to replace are memo fields.

Are the fields that you are trying to replace MEMO fields? If so use the MEMO key word in scatter and gather commands.

USE xldata
SCATTER memvar MEMO
USE nan
*!* either append blank or seek correct record to update
if eof("nan")
    append blank 
endif
&& i need to replace (delete all data replace new data)
GATHER memvar field EXCEPT char28 MEMO

>hi,
>thank you for reply.
>
>i try nothing happend,
>

>USE xldata
>SCATTER memvar
>USE nan
>*!* either append blank or seek correct record to update
>append blank && i need to replace (delete all data replace new data)
>GATHER memvar field EXCEPT char28
>
>

>
>thanks.
>best regards.
>m.qasem