>Hi to all,
>
>Is there a way to know if a table is locked in the middle of a transaction before opening it?
>I tried using flock() but this works only if the table is open. What about checking a table lock status if it is closed? Isn't there a function as "locked()"?
>
>Thanks for your help,
>
>Fausto

Fausto,

A transaction should take as little time as possible. Open the tables before the BEGIN TRANSACTION.