Jay Johengen
Altamahaw-Ossipee, Caroline du Nord, États-Unis
Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Using Views and Update Key(s)
I'm have a view that uses social security number (SSN) as the update key. I noticed that all records with the same SSN were getting updated. I added last name, first name and date of birth as keys and it worked fine. Is there a way to have only the current record update without explicitly stating specific fields? What does the database check when you mark "No duplicates?" The database knows that they are not the same records somehow, but when I update it seems to require the additional keys. Thanks!
Regards, Renoir
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