Here it the code I use to gen the dbc, and the view. at the end it tries to add a record to WO.DBF via the view. tableupdate() reutns .f., and message() reutrns "No update tables are specified. Use the Tables property of the cursor."
Here you will find UrDbc.prg that gens the dbc. sorry about all the extra tables, but this is right from my live project, and if I start hacking it apart, I may 'fix' it. T3dbc.prg is my attempt at a small 3 table version, but it works....
http://24.131.155.182/carl/tmp/ur3/data/to answer the obvious questions:
DBSetProp('LV_WOMAIN', 'View', 'UpdateType', 1)
DBSetProp('LV_WOMAIN', 'View', 'WhereType', 1)
DBSetProp('LV_WOMAIN', 'View', 'SendUpdates', .T.)
DBSetProp('LV_WOMAIN', 'View', 'Tables', 'wo')
dbsetprop( 'lv_WoMain', 'view', 'ParameterList', ;
"vp_cPONumber, 'C'; vp_cInvoiceNum, 'C'; vp_cJobNo, 'C'; vp_cNum1106, 'C'" )
DBSetProp('LV_WOMAIN.pkwo', 'Field', 'KeyField', .T.)
DBSetProp('LV_WOMAIN.pkwo', 'Field', 'Updatable', .F.)
DBSetProp('LV_WOMAIN.pkwo', 'Field', 'UpdateName', 'ream!wo.pkwo')
DBSetProp('LV_WOMAIN.pkwo', 'Field', 'DataType', "I")