>Hi,
> Thank you for reply. How could I FLUSH more than one table in transaction?
>
>Thank you

The FLUSH command commits all the changes you have made in all tables that are open. It essentially forces all changes, that are perhaps cached in memory, to be written to disk. This only applies to local machines. FLUSH doesn't force a network server to write to disk.

Hope this helps.

Tom