Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Problem Creating Updatable Cursor with SQL
Message
From
19/04/2000 11:41:47
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Client/server
Title:
Problem Creating Updatable Cursor with SQL
Miscellaneous
Thread ID:
00361321
Message ID:
00361321
Views:
44
Why doesn't the following code work? The password field never gets updated on the backend.

lnHandle=SQLCONNECT("SQLFiles")
=SQLEXEC(lnHandle,"SELECT * FROM customer","clients")
=CURSORSETPROP("Tables","customer","clients")
=CURSORSETPROP("KeyFieldList","customerid","clients")
=CURSORSETPROP("UpdatableFieldList","password","clients")
=CURSORSETPROP("UpdateNameList","password customer.password","clients")
=CURSORSETPROP("SendUpdates",.T.,"clients")
=CURSORSETPROP("Buffering",5,"clients")
select clients
** browse and update password field on one record
=tableupdate(1,.t.)
use
=SQLDISCONNECT(lnHandle)

Thanks in advance for your help.
Next
Reply
Map
View

Click here to load this message in the networking platform