Hi Clarissa,

Argh. Transactions can only be used on tables in a database. OK, another way to do this would be to get a file flock (FLOCK()) on one of the tables and then update both tables (use an RLOCK on the non-file locked table) and then unlock both tables.

>I do not use BEGIN...END TRANSACTION and I don't use DBC, all my tables are free tables.
>
>The transaction table contains the details of Sale and Purchase data.
>
>Should I use BEGIN...END TRANSACTION?
>Can I use BEGIN...END TRANSACTION with free tables?
>
>Thanks and Best Regards,