>>Jim,
>>
>>I am looking for an easy way of committing all buffered table back to the disk. Can I use the old flush command to commit everything at once?
>
>FLUSH will write data already committed to the file but possibly held in local storage; it will not do a TABLEUPDATE() or END TRANACTION to commit data held in buffers. You still have to TABLEUPDATE() on each view/table, and END TRANSACTION on any pending transactions, before FLUSH can force the physical write to take place.
Just a note, FLUSH does not work in a mult-user environment unless the tables are used exclusively. Checkout the MS Knowledge base article ID: Q136579
-TomC