FLUSH only clears the cache on the local PC. It does nothing with the write cache on the server.
>Albert,
>been there done that. If the DBFs and the query program are on the same server then you will not pick up the changes from the other side right away. I fixed the problem by closing the tables before each query. Yea, FLUSH is supposed to do that but not always and closing and reopening the tables is instantaneous.
>HTH
>
>John
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer