> 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
Server
Upscene Productions
http://www.upscene.com
Database development questions? Check the forum!
http://www.databasedevelopmentforum.com