How to refresh view in all workstation ?

[jytrd]

I have table in Sql server 7.0 , and I browse in visual foxpro on the view. I insert data to these table.
But at the other workstation the table not updated.
How to refresh data on the online view ?



Thanks,

Rudi
[sig][/sig]

 

[jnicho02]

Sounds like visual foxpro is caching the data locally, a SQL Server view would update immediately. [sig]<p> <br><a href=mailto: > </a><br><a href=

http://www.geocities.com/jnicho02/>my

home</a><br> [/sig]

 

[guest1]

Did you try the REQUERY() function to refresh the data in the remote view? If the data is added in the VFP remote view, it must be committed with a TABLEUPDATE() call. To refresh the local cursor on the other workstation with the most recent data, use the REQUERY() function