Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
>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.
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement