General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
>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.
I never used Sybase SQL Anywhere as a backend, but I had the same problem when I did not exclude primary keys from the updatable fields.
-Yelena
Previous
Next
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