I was getting an Update Conflict error when I would try to make changes to data in a view. The view is a remote view of a SQL server table.

I discovered that if I key new data into the table, I did not get the problem. The problem occurred only when I tried to edit existing data.

So I created a new table on the SQL server using the same field characteristics. I ran an INSERT INTO command on the SQL server using a SELECT statement to populate the new table with the old data.

The new table had the same problem in VFP. I deleted all the records and tried this: In VFP I selected all the data of the first table into an array, and then I inserted into the new table from the array. Now it works fine!

Jeff