General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
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!
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only