VadhLee,
I am not sure that I understand you correctly, but I guess you will get what you want if you use Append blank before Replace. Or even better, use the SQL command Insert which will do both in one line
Insert into yourtable (field1, field2, field3) values (value1, value2, value3)
>hello all..
>
>I'm a data collector, need you're help to know how to Save updating data without replacing old data record, What command should be use to save except Replace. it's same like using "Save As" the document in Ms.Word or etc. as I knew if Visual Foxpro always record/save data using "Replace", I though if I use replace my old data will be change and lose. Hopefully will got answers soon..
>
>thxs..
>
>Regards
>
>VadhLee