Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Update conflict when updating Sybase SQL Anywhere databa
Message
From
07/11/2007 14:27:12
James Blackburn
Qualty Design Systems, Inc.
Kuna, Idaho, United States
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
01267318
Message ID:
01267373
Views:
13
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
Map
View

Click here to load this message in the networking platform