Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
How to update source table with record appended to view
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Divers
Thread ID:
00098177
Message ID:
00098256
Vues:
32
Sylvain is correct, but in addition you must have your view set to be updateable. Go to the View Designer and make sure ALL the fields in your table are marked to be upadated, that you have checked the "Send SQL Updates" box (easy to miss) and that your primary key is marked.

Finally, if your underlying table is buffered you will have to issue a second TableUpdate() to the base table.

HTH
Barbara


>Issue a TableUpdate() on the source table.
>
>HTH
>
>>My work with views continues. I am now trying to update the source tables with changes made in a local view. I am able to update existing records, but can't seem to have my view's newly appended records to also be appended to the source table.
Barbara Paltiel, Paltiel Inc.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform