Information générale
Titre:
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.
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement