How to create an updatable view to update data in underlying tables in Visual FoxPro

MORE INFORMATION

Step-by-Step Example to Create Updatable View that Updates Underlying Table

1. Open the TestData database in SAMPLES\DATA directory. Type MODIFY DATABASE in the Command window to open the Database Designer.
2. Right-click the background. Then choose New Local View, and then choose New View.
3. Choose the CUSTOMER table from the Add Table or View list.
4. In the View Designer, click the Fields tab, and add the CUST_ID and COMPANY fields to the field list.
5. In the Update Criteria tab, click next to CUST_ID in the key column. Then click next to COMPANY in the pencil (updatable) column. Select the "Send SQL Updates" check box.
6. Select the Key Fields Only option.
7. Save this view as UpdCust, and leave the View Designer.
8. Right-click the view, and choose BROWSE. Change a company name, and then close the BROWSE. When the view is closed, the database designer becomes the active area.
9. In the Command window, close the view by issuing USE, or issue =TABLEUPDATE().
10. Right-click the CUSTOMER table in the Database Designer. Choose BROWSE. Notice that the changes made to the view's COMPANY field have been passed back to the CUSTOMER table's COMPANY field.

Same Example in Code

CREATE SQL View UpdCust AS SELECT cust_id, company ;
   FROM testdata!customer
=DBSETPROP('updcust.cust_id','Field','KeyField',.T.)
=DBSETPROP('updcust.company', 'Field','UpDatable',.T.)
=DBSETPROP('updcust.cust_id', 'Field','UpDatable',.F.)
=DBSETPROP('updcust','View','WhereType',1)
=DBSETPROP('updcust','View','SendUpdates',.T.)