Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Problem Creating Updatable Cursor with SQL
Message
De
19/04/2000 11:41:47
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Client/serveur
Titre:
Problem Creating Updatable Cursor with SQL
Divers
Thread ID:
00361321
Message ID:
00361321
Vues:
45
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
Fil
Voir

Click here to load this message in the networking platform