Subject Re: [ib-support] Locking records with IBX
Author Svein Erling Tysvær
At 14:19 21.12.2000 +1300, Sandeep wrote:
>On 20 Dec 2000, at 15:36, Jason Wharton wrote:
>> It is probably because you are using autocommit and it makes no sense to
>> perform the dummy update if it is just going to be autocommitted. IBO's
>> autocommit and PessimisticLocking property will automate this for you. I
>> suggest you give it a look.
>I'm not using IBO. I'm using IBX. And I don't think there is any such
>property in IBX.

Transactions are part of IB - regardless of whether you use IBO or IBX.
What Jason basically was saying is that the "update foo set pk = pk" record
locking and your changes should both be within the same transaction (i.e.
don't do any commit between them).