>I am having a problem with a view of a MS SQL Server table. When I try to modify certain records I get an Update Conflict error. This only happens with certain records, not every record. I have no problem modifying the data using MS Query.
>
>For two records, I deleted them and then rekeyed the exact same data. The problem went away.
>
>The table has three key fields: claim_number (Integer), dt_time_stamp (datetime), and payment_number (Integer).
>
>I have fixed the problem for two records but I am concerned that this problem will affect other records.
>
>Help?
Do you have any of these fields marked as the Primary Key in the 'Update Criteria' of the remote view? Even if you feel you don't need it on the SQL Server side, VFP requires this to update a remote view.