Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Tableupdate() & cursorsetprop() for multiple remote tables
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Tableupdate() & cursorsetprop() for multiple remote tables
Miscellaneous
Thread ID:
00670124
Message ID:
00670124
Views:
58
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
Map
View

Click here to load this message in the networking platform