Walter Meester
HoogkarspelPays-Bas
Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Hi Andrus,
Hmmm, sad it didn't work out.
The problem you are facing is the problem of dirty buffers. I guess there are only a few ways to force the buffer to refresh.
1. Using RLOCK (only current record)
2. Using FLOCK
3. Closing the table and loading it again (but the table must be closed entirely, so other open aliases also).
4. Using SET REFRESH
It seems that in your case using SET REFRESH might be the only option you've got. It seems that you can have a 0.1 for the second parameter, but don't now if this works properly, maybe you can try. However one more suggestion thoug:
Just issue a SET REFRESH TO 0,1 (and INKEY(1.5) just before you execute the query and restore its value after it has been completed. Setting SET REFRESH is not scoped to the current datasession so restoring the old value gives less network trafic and could be a performance advantage in other forms.
I hope this helps.
Walter,
Précédent
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