Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Tableupdate() & cursorsetprop() for multiple remote tables
Hello everyone,
I have a cursor that is created by doing a left join on two remote tables. Both tables have the same primary key (mailboxId) and what I want to do is be able to use cursorsetprop() and tableupdate() on the cursor and each table will be updated accordingly. Right now I can only update one table and when I change data for the other table, I get this error:
"No key columns are specified for the update table 'dbo.employerRegistrationInfo'. Use the KeyFieldList property of the cursor."
Like I said, both tables (employerContactInfo & employerRegistrationInfo) have the same primary key (mailboxId). What do I need to do in order to make both tables updatable? Is this possible to accomplish? Any assistance would be greatly appreciated. Thanks!
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