Have a close look at the SET REFRESH command. Even though the preamble says clearly that it is effective only for BROWSE windows, that is NOT the case.

Note that VFP9 give much more flexibility as regards this problem.

Using SET REFRESH in your VFP6, keep in mind that it only takes integer values for its arguments.
Also you need to know that the time intervals you set in the command do not guarantee that buffers will be updated every 'n-specified' seconds. Rather, this time is examined when an I/O is initiated and if the interval has lapsed then the refreshing is performed.
I believe that you can safely force this to happen by issuing a simple

GO RECNO() IN < alias >

good luck


>Hi everyones,
>
>In a multi user environment, all my forms use private datasession and all my tables are open with buffered mode 5 (optimistic table locking).
>
>Now when two users look at the same table and one user change the value on one record how can I "force" the display on the second user screen to be "refresh" with the new data? It can be a manual command (like whenever a user click the "update" button, the program will force a refresh first). I know for a view but the programs use vfp tables directly.
>
>BTW sometimes it seems the refresh is done automatically and sometime not. I don't understand the behavior. Any theoritical explanation is welcome.
>
>TIA