Keith,

Are you sure you reset the set refresh command for each datasession? The command is scoped to the current datasession.

Walter,


>I have a problem in an application using both native tables and view. When a native table is updated (appended/deleted records) on one workstation, a second workstation does not see those records. This happens despite the settings of SET REFRESH. Once a local view that uses the table is requeried, in any data session, the buffers get refreshed. But until then... nothing. It’s almost as if SET REFRESH stopped working for native tables at a certain point. Any advice?
>
>I will try to provide as many details as I can.
>
>- The app is compiled in VFP 6.0 SP3.
>- The SET REFRESH setting is 0,5. But the behavior also occurs with 1,1; 2,2... and any other settings that I try.
>- No action I take on the updating workstation seems to have an effect – TableUpdate(), USE IN, Flush, etc.
>- The table buffering state, and transaction level (if any) does not have any effect.
>
>Interestingly, on the workstation with the buffered data, if I suspend and BROWSE, the data is refreshed. And as I mentioned, if I execute a view that queries this data, in any workstation, that also works. Also, this problem does NOT seem to occur
>
>From a response on message 189620 I found a suggestion to update local buffers, and this does work:
>SELECT table
>RLOCK()
>UNLOCK
>
>Unfortunately, this will require changes in hundreds of programs, and I was hoping for a more global solution/setting.
>
>Any advice is appreciated in advance.