General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
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... :)
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only