TIB_Query.PessimisticLocking:=True and TIB_Query.IB_Connection:=tiCommited should do the job (at least to me:)

Mit freundlichem Gruss & Best Regards

Andreas Pohl
apohl@...
www.ibp-consult.com

----- Original Message -----
From: "Riho-Rene Ellermaa" <r.ellermaa@...>
To: "IBObject (E-mail)" <IBObjects@yahoogroups.com>
Sent: Monday, October 15, 2001 12:03 PM
Subject: [IBO] Problem with multiple users editing


> Looks like I don't get this multiple users editing same record stuff.
>
> My transasction is tiCommited, AutoCommit=true, lockwait=false.
> In BeforeEdit I call StartTransaction().
>
> But still, when I run two instances of my program, nothing stopps me from
> editing same record in both programs. I start editing in 1, then start
> editing in 2, post 1,post 2 - and the winner is 2.
> Is the only solution to make EditSQL check all fields for old values? It
> would be better to warn 2. user in the beginning, that this record is
> already in edit mode.
>