Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Not updating data in backend
Message
From
10/09/2002 12:55:14
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Not updating data in backend
Miscellaneous
Thread ID:
00698878
Message ID:
00698878
Views:
52
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
Next
Reply
Map
View

Click here to load this message in the networking platform