Walter Meester
HoogkarspelNetherlands
General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
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,
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only