Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Update conflict when updating Sybase SQL Anywhere databa
Message
 
To
08/11/2007 08:31:41
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
01267318
Message ID:
01268179
Views:
9
>PMFJI, but, updateable fields means that the field can have a different value in it then what it started with. You do not want the primary key to change - I hope. You just want the primary key to ID which record you are working with, correct?

Yes I do not want to update the primary key field. Primary key is only for relation to update. I made the primary key field only key field not updateable. For example I want to update the total points for customer who's ID is 7854. When i include customerid (primary key) field in view with key field mark only then I get update conflict error.
Is there any alternative way to update a specific record not all the table. If I remover the primary key field as key field it will update all the records in a table. I want to restrict the update to a specific record.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform