Hi!
You may do this by native VFP way.
Look to following article in the MSDN Help:
Programmer's guide, Chapter 21 "Implementing a Client/Server Application", Working with Remote Data Using SQL Pass-Through, "Updating Remote Data with SQL Pass-Through". Here you will find properties of cursor required to set to make it updatable like a remote view. Here is a link you can use to look for samples how to do this successfully (there are some tricks with property value formats):
http://www.tek-tips.com/gviewthread.cfm/lev2/4/lev3/27/pid/184/qid/25617>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... :)
Vlad Grynchyshyn, Project Manager, MCP
vgryn@yahoo.comICQ #10709245
The professional level of programmer could be determined by level of stupidity of his/her bugs
It is not appropriate to say that question is "foolish". There could be only foolish answers. Everybody passed period of time when knows nothing about something.