>Hi,
> I am developing stand alone VFP Application. I used to have Buffering for my table and view. When I test my application, I get UPDATE CONFLICT SOMEWHERE.... and cannot be REVERTed.....using TABLEREVERT(.t.). It cause me failed to exit VFP. What factor usually cause this ERROR?
> I found that my more than 100 records deleted in my .DBC witout pack. Then I pack it and ERROR Update Conflict is not appear anymore, why?
> Do I need to set datasession to Private Datasession instead of Default?
>
>Thank you


Generally, an Update Conflict comes from the fact that the key field used in the update does not have a unique value in the table and VFP when updating does not know which record to update. If you are using primary id's in the table and that field becomes the update field, your referential integrity will protect against an update conflict. The reason that it may be working when you pack the table is that once you mark a record for deletion, you are reusing the update key such that when VFP tries to update the record, it doesn't know whether to update the undeleted record or the one marked for deletion. When you pack the table, you remove the ambiguous record.

HTH

Bill