>I have been developing applications in Visual Foxpro for sometime and have now been given the task to write a small application using VFP as the front end performing SQL on a SQL Server database.
>
>I can handle the queries on the SQL Server. My only problem is when I perform a query and if the user modifies it in the VFP cursor. How do I then update this change to the database. Any help would be appreciated.
>
>Thanks
>
>Suleman
The general rule is:
1. Use Pass-Through SQL to get non-updatable data from SQL This case it's very convenient to write Stored procedures on SQL-server and call them using SQLExec(nConn,"Execute StorProc1 "...).
2. Use buffered remote view to get updatable data and use TABLEUPDATE() and similar stuff to handle it.
Edward Pikman
Independent Consultant