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,
------------------------------------------------
John Koziol, ex-MVP, ex-MS, ex-FoxTeam. Just call me "X"
"When the going gets weird, the weird turn pro" - Hunter Thompson (Gonzo) RIP 2/19/05