>>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.
Ed,
Thanks. That's just what I wanted to know. VFP help does not make this relationship very clear.
regards,
Jim Edgar
Jurix Data Corporation
jmedgar@yahoo.comNo trees were destroyed in sending this message. However, a large number of electrons were diverted from their ordinary activities and terribly inconvenienced.