----- Original Message -----
From: "Chooi-Ting" <goonct@...>
To: <firebird-support@yahoogroups.com>

> hi,
>
> does anyone know how to change lock resolution from wait to nowait ?
>
> rgds, chooi-ting
>

My understanding of lock resolution is it works on a per transaction basis,
and so how you specify it depends on the client library you use. In basic
'C' terms using the gds32 library (or the newer fbclient library) is you
specify the lock resolution in the TPB (transaction parameter block/buffer)
using the 'isc_tpb_wait' or 'isc_tpb_nowait' constants.

From the IB 6 docs (ApiGuide.pdf), when starting a transaction:
static char isc_tpb[] = {isc_tpb_version3,

isc_tpb_write,

isc_tpb_read_committed,

isc_tpb_no_rec_version,

isc_tpb_wait};


so you could try that. I use the IBPP library for C++ and its done
differently there.

Andrew Gough
LiveNote Technologies Inc.