>>VFP keeps track of what are new and what are current records (to decide whether to INSERT or UPDATE) with the Fieldstate of the view. When checking GETFLDSTATE-1) on oyur view before tableupdating, does it show 2s or 4s?
>
>
>I changed one field in a visible record and GetFldState says:
>34444444444444444443
This is the problem. VFP thinks that the record in the view is a newly appended record. Is this record in the view from a REQUERY(), or are you putting it there? Either way, you can fool VFP into thinking that the record is not new by using the SETFLDSTATE() function to change all of the field states to 1 and 2.
Erik Moore
Clientelligence