General information
Title:
Problem Creating Updatable Cursor with SQL
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
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only