Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Why dosn't my view update?
Message
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Why dosn't my view update?
Miscellaneous
Thread ID:
00365855
Message ID:
00365855
Views:
50
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")
Next
Reply
Map
View

Click here to load this message in the networking platform