General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
It has been a long time since I used views but you might check the WhereType property. If you are using anythink but 1 then it could cause this if another user changes the table (I think).
>I have a remote view to update Sybase SQL Anywhere version 5 database. The parent table has a valid primary key and I have selected the updateable field and primary key field and also Send SQL updates is checked. Now when i run the view and try to update the updateable field it gives me error Update confilct. There primary key in parent table is unique and there is no any primary key voilation. I have tried by using different Where SQL clause but no success. Please reply me if someone have some solution to update Sybase SQL Anywhere version 5 using vfp9.
Previous
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