Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How do I to Update a Table from one SQL View
Message
 
 
To
17/09/1998 17:01:10
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00137964
Message ID:
00137970
Views:
21
>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
Previous
Reply
Map
View

Click here to load this message in the networking platform