Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
SQL Server and FoxPro
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
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