Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Update conflict when updating Sybase SQL Anywhere databa
Message
From
12/11/2007 10:34:11
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
01267318
Message ID:
01268506
Views:
12
>>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.

Hi Zaheer,

Sorry, but I do not know that much about view. Hopefully, someone else will jumping in with more help.

Beth
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform