>In a Web environment, I have 4 VFP servers running to process the incoming requests. I have found that occasionnaly, one save by a VFP server is not reflected immediately on another VFP server. What I mean by that is that it may takes up to two seconds before the other servers can read the updated data from the tables.
>
>It seems that I have to force a flush here.
>
>What would be the best approach to make sure all data is saved on disk immediately after the VFP server that did the save transaction?

There was discussion about a similar problem but programs modifying table were located on separate PC's. If I remember correctly the solution was, in addition to what VLAD suggested, to RLOCK(myalias,0) to lock table header before read to make sure that updates from another program are visible.