> -----Original Message-----
> From: Guillermo Najar-Arreola [mailto:gnajar@...]
> Sent: Tuesday, October 01, 2002 2:33 AM
> To: ib-support@yahoogroups.com
> Subject: [ib-support] Exclusive Lock
>
>
> Hi,
>
> I have a process that must be done just if NO user is
> accesing any record on
> a specific table. On my desktop application experience, this
> could be done
> setting an exlusive-lock on that table. I know that Firebird
> 1.0 as other
> SQL Servers, have an optimistic-lock scheme for multiuser acces.
> How can I achieve this exlusive-lock in Firebird for a table?
> I'd like not
> doing it from my application using flags that usually are not
> as solid as
> any built-in mechanism on the DB Server.

Try use table reservation option on start transaction.
Look to api documentation (isc_start_transaction, isc_tpb_shared,
isc_tpb_lock_write ...).

Zdenek