Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
SQL Server and FoxPro
Message
De
11/10/2000 13:10:00
Erin Eby
Mission Critical Software
Gainesville, Floride, États-Unis
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
SQL Server and FoxPro
Divers
Thread ID:
00427928
Message ID:
00427928
Vues:
47
Hi all! Happy Wednesday! I have a question concerning sql server and updating tables. I am connecting to the sql server using an sqlconnect statement. After getting a successful connection, i am using an sqlexec statement to grab records from the sql table and put them into a cursor:

ln_exec = SQLEXEC(ln_connect, "SELECT * FROM sqltable", "c_cursor")

After updating my cursor within FoxPro, I need to send the updated records back to sqltable. I have been told that i can use ADO to update that table (sqltable). I have never worked with ADO, and the only way I know to do it is using an API (stored procedure) that is stored on the sqlserver as well. I am attempting to use ADO, but I need a little direction. Any clues? tia... :)
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform