Hi!
After transaction, FLUSH is required to update table headers only for correct number of records after new record inserting, I know also it flush buffered data in case you use table with no buffering.
sys(1104) could help another app to see changes immediately.
>>The buffers I meant are not the buffers used for different buffering modes for tables. These are internal VFP memory buffers used to cache data for best performance. Even after tableupdate() there could be left something in memory not written to disk immediately. FLUSH will assre content of these buffers written to disks completely.
>>
>>Yes sys(1104) could help, as well as suggestion from Sergey. Just test with first, second or both.
>
>I am looking for a way to do that generally. I would like to put that at the end of each transaction. Is a single FLUSH flushes all data of all tables or it's only on the actual table?
Vlad Grynchyshyn, Project Manager, MCP
vgryn@yahoo.comICQ #10709245
The professional level of programmer could be determined by level of stupidity of his/her bugs
It is not appropriate to say that question is "foolish". There could be only foolish answers. Everybody passed period of time when knows nothing about something.