Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Update an mdb database(access)
Message
De
07/06/2004 15:32:26
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Update an mdb database(access)
Divers
Thread ID:
00910886
Message ID:
00910886
Vues:
47
Hello,
I have a curso un VFP, in it i have number of documents, this documents have a field with .T., I want update this field in an access database.
For example i have:
vfp cursor -> micursor
field of the cursor ->nrodoc
field of the access table -> documento
odbc for access -> miodbc
table of access -> mitable
field of table for update -> estado

manejo = sqlconnect("miodbc")
=sqlexec(manejo,"update mitable set estado = .t. where document in micursor))
=sqldisconnect(manejo)
Could you help me ?
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform