General information
Title:
Update Conflict - Update to my problem (this is wierd!)
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
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only