>>Hi Vlad,
>>
>>Seems it is not exactly right. FLUSH sends the command to write the data on disk and data are passed to operating system. At this point the data are saved on disk as far as FoxPro concerned, but they still may be in network buffers/cache somewhere until they are really written to disk.
>>
>
>Hi!
>
> There are certain OS functions that tell it : DO NOT BUFFER THESE DATA, WRITE IMMEDIATELY. That what VFP uses for FLUSH command. This greately increases reliability.

I had a problem with one FoxPro DOS application (not mine). It used commonly approved scheme of getting unique IDs (lock the table, increment value, unlock) When moved to NT network (Token Ring) it started to give duplicate IDs. Using FLUSH didn't affect this behaviour at all. It was tracked down to NT server cache, but it was not possible to turn it off as other app started to fail after that.