Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
How do I write records to an MS Access table?
Message
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Titre:
How do I write records to an MS Access table?
Divers
Thread ID:
00345161
Message ID:
00345161
Vues:
38
I can do this much, which gets me a list of the tables in a chosen .MDB file stuck into the ACCTABLES cursor.
My goal is to be able to add records to the customer table in the open database, but I guess my SQLEXEC function isn't the way to go about it...
How far off am I?

sh = SQLCONNECT() && Will ask me what I want to connect to
retval = SQLSETPROP(sh, 'Asynchronous', .F.)
retval = SQLTABLES(sh, "TABLE", "ACCTABLES")
retval = SQLEXEC(sh, [INSERT INTO Customer (firstname, lastname) VALUES ("first_name", "last_name")] )

retval = SQLEXEC(sh, "SELECT * FROM Customer", "custcopy")

SELECT custcopy
BROW && And it's still empty!

What should I be doing?

Thanx!
Independant Foxpro Developer
Spring Hill, FL
jpirola@tampabay.rr.com
352/686-8373
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform