Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Not updating data in backend
Message
De
10/09/2002 12:55:14
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Not updating data in backend
Divers
Thread ID:
00698878
Message ID:
00698878
Vues:
51
close database all 
open database d:\datasets\testdata

create connection testconn datasource 'dsnname' userid 'username' password 'password' database 'backenddata'

create sql view test connection testconn shared as ;
	select * from backenddata.item_master

use testdata!test in 0
index on item_id to test

* Tables, KeyFieldList, UpdateNameList, UpdatableFieldList, and SendUpdates
cursorsetprop("Buffering",5)
cursorsetprop("Tables","test")
cursorsetprop("KeyFieldList","item_id","test")
cursorsetprop("UpdateNameList","itemdesc","test")
cursorsetprop("UpdatableFieldList","itemdesc",'test')
cursorsetprop("SendUpdates",.t.)
I ran this from a program; browse the view; made changes to itemdesc and in from command window; issued TABLEUPDATE(.T.). However, the changes aren't sent to the backend database. What am I missing here?
ramil
~~ learning to stand still
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform