Subject Re: [firebird-support] Locking a Table
Author Martijn Tonies
> How do I lock and unlock a table so that there can be no concurrent
> updates/inserts to that table ? I am using the C API.

You cannot.

You can lock the records by doing a dummy update, eg:

update mytable set pkfield = pkfield

Next, other transactions will receive a deadlock error.

Any reason why you want to "lock a table"?

Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, Oracle & MS SQL
Upscene Productions
Database development questions? Check the forum!