>>I am accessing SQL Server 2000 data from FoxPro. I am making my connection to the SQL server with SQLSTRINGCONNECT. I use SQLEXEC to make the SQL Select that builds my cursor. I then use the appropriate CURSORSETPROP calls to make the SQL Pass Through Cursor updateable. However data in this cursor never updates if some other user makes a change to the table. Let's say another user adds a new record from a different workstation. The cursor on this one doesn't show that new record. I have SET REFRESH TO 0,5. Shouldn't it update the data in the cursor every 5 seconds from the SQL server? What am I missing?
>
>SET REFRESH doesn't work with external (not VFP) data. You have to re-select data from the SQL Server to get updates.

Can we get around this by using a remote view? Is it possible to get a remote view to update automatically?