Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Update conflict when updating Sybase SQL Anywhere databa
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
01267318
Message ID:
01268506
Vues:
13
>>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
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform