--- In firebird-support@yahoogroups.com, "kevtey" <kevtey@...> wrote:

>
> hie im new in firebird. i would like to know how can i impliment
> record locking in firebird? can anyone pls enlighten me pls...
>
> currently im accessing the firebird from vb using connectionstring and
> recordset. i try using pesimistic lock but its not working...should i
> use adodb connection begintrac?
>

You mention you are new to Firebird, I will not address you particular
question as both Jason and Si have given you two ways of achieving
this (see release notes for details on Si's method).

I only warn that there are very few occasions in Firebird where a
pessimistic lock is actually necessary. In Firebird, readers and
writers do not block each other due to multi generational
architecture. With some DBMS, it is necessary to block writers when
totalling records etc, with Firebird, there is no need to. So my
advice is to make sure you actually need to use pessimistic locking or
you are giving your system an unnecessary scalability limitation.

Adam