Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
How do I to Update a Table from one SQL View
Message
 
 
À
17/09/1998 17:01:10
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Divers
Thread ID:
00137964
Message ID:
00137970
Vues:
20
>I Create a SQL View to capture data in a form, but i don´t know to update the table.
>
>
>Thank You.

In the view designer, click on the Update Criteria tab. Make the view updateable by identifying the key field (put a check mark under the key symbol by the key field). Put check marks under the pencil symbol next to all the fields to update. This will activate the *Send SQL Updates* check box. Check it.

If you do a GENDBC found in home() + "\TOOLS\GENDBC" directory, this will generate the code for your DBC. Then if you modify this .PRG, you can see the actual code involved in making a view updateable [CursorSetProp() functions].
Mark McCasland
Midlothian, TX USA
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform