Hi Andrus,

In stead on using a RLOCK(), you might want to try a FLOCK() or alternatively close it and use the table again before you issue the SQL-SELECT

Walter,


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