Carl: Great idea for posting a URL to look at the code.

Why not run GENDBC against the DBC after LV_WOMAIN is created and save that to another file? There is a property messed up somewhere and it ain't one of those in the code. Do that and I'll look at it again.





>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")