>All,
>I have a question for Foxpro 2.6
>
>Refresh: This command determines whether or not your screen displays changes made to records by other users on the network.
>The fastest refresh interval seems to be once per second. Is there any way this can be done faster?
>If not, is there any other, faster way to see a table update made be another client ?
>
>Thanks for the respond.
>Angela:)

To answer your question, you can manaully update the data from the network by issuing an RLOCK() in the table and then releasing it. Using this in FPW is problematic because there is no timer object that runs without hogging the processor.

Do you really need updates to display faster than 1 second?

FoxPro caches data locally in memory (physical and virtual disk) so it can display blazing performance. Set Refresh determines the time interval to update the local cache from the network. Depending on the speed of your network and the size of your tables, FPW could be take longer than 1 second to update its buffers and then immediately go into another buffer update. I had applications "freeze" because the cache was being updated and the user couldn't do anything else. If this is a perpetual thing, your users won't be happy.