Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Why dosn't my view update?
Message
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Why dosn't my view update?
Divers
Thread ID:
00365855
Message ID:
00365855
Vues:
49
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")
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform