>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