Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Tableupdate() & cursorsetprop() for multiple remote tables
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Tableupdate() & cursorsetprop() for multiple remote tables
Divers
Thread ID:
00670124
Message ID:
00670124
Vues:
55
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
Fil
Voir

Click here to load this message in the networking platform