In short, InterBase is designed with optimistic concurrency. I rather like
it and applaud it, once you understand how it is supposed to work. Dealing
with locks and such are really a chore and awful compared to what
transactions allow.

FWIW,
Jason Wharton
CPS - Mesa AZ
http://www.ibobjects.com

----- Original Message -----
From: <guido.klapperich@...>
To: "ibobjects@egroups.com" <IBObjects@yahoogroups.com>
Sent: Monday, February 12, 2001 7:01 PM
Subject: [IBO] PessimisticLocking


> In my opinion 'PessimisticLocking' is a fine feature of IB_Query,
> because it says the users, that someone is already editing the record
> BEFORE he starts to edit the record. I only wonder, why this feature is
> not property of a Interbase-Transaction, because I don't think it's very
> userfriendly, to say a user AFTER editing a record, sorry someone was
> faster, try it again later.
> The developers of Interbase will surely thought about that and they
> decided not to implement it. But I don't see the reasons for this, can
> anybody explain it to me ?
>
>
> Guido.