Information générale
Titre:
Local Buffers and SET REFRESH
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.
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement