I have a shared non buffered dbf file. I need to get latest data from it using SQL SELECT command.
I have a command
SET REFRESH TO 0,1
in my form init.
If records are added to this shared dbf file by other instance of VFP,
SQL SELECT in another instance does not find added rows.
This occurs on LAN or if two vfp programs are running on local computer using same dbf file.
I discovered that adding a line
inkey(1.5)
before SQL SELECT fixes this behaviour: SELECT then returns latest data.
However, adding inkey(1.5) 's before SELECTs decreases program speed.
How to force VFP to refresh its local buffers immediately ?
Andrus