>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... :)
You can do that with disconnected recordsets and the UpdateBatch method of the ADO recordset object. As usual, a good place to start if you're new to ADO is John Petersen's white paper in msdn:
http://msdn.microsoft.com/library/techart/adojump.htm