The SET REFRESH command is used to set up background refreshing of locally cached data. If you want to explicitly update the local cache then you can issue an RLOCK() on the table and immediately release it. VFP will refresh the buffer on a successful lock.

HTH.

>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 ?