>This sounds good. How can I improve the tableupdate performance using stored procedures? I thought that the view was the stored procedure and that when I used tableupdate that the view was used to update the table????? I not very sure of any of this because I've only just started using SQL 7. TIA
>John

Hi John -

I remote view in VFP is nothing more than a visual method of designing a remote SQL query. In fact, if you right click in the View Designer you can see generated SQL code. A stored procedure is written in Transact-SQL and stored at the SQL Server. You can call a stored procedure from VFP using SQL Pass Through (SPT) techniques. A stored procedure is precompiled and stored at the server along with its access plan to speed execution. A tableupdate() issues the UPDATE ... command against the remote table.

Run the SQL Trace (SQL 6.5) or Profiler (SQL 7.0) programs to watch the activity passed to the SQL Server from your application. It is pretty interesting.

Mike