Hi Mark,

I am using table buffering.

Also I have generated the Primary Key....strange, huh? So to recap, I create a record in the view create a primary key....go to another record in the view and then come back to the "added" record and make a modification through a bound text box and then when I try to move off of that record I get this Update Conflict error.

I am using a VFP backend. Also I do have the base table in the DE with table buffering if this has anything to do with it....

Thanks a ton,

Paul

>>I have a view where some new records have been added. I then scan through the view and issue a replace on a record that was just added and I get this error message "Update Conflict" when I hit the endscan to move to the next record in the view.
>>
>>How can I avoid this?
>
>Are you using row or table buffering? I have had a similar problem [my own fault] where I added a record to a view with no KeyID [the KeyID is generated when written back to the source table where I have defaulted the KeyId to be GetPrimaryKey("TableName")]. So while I am working with the view, any new records have a KeyID of zero and they still do not exist in the source table. If you use record buffering, you could have triggered an update that wrote the new records to the source table. The source table now has these new records but with a legitimate KeyID. However, the KeyID in the view is still zero. They will remain zero until you requery() which can be bad if you have uncommitted changes.
>
>What is the backend? VFP? Oracle? SQL Server?