Adrian,

Ok, I see what I did that caused PessimisticLocking to fail in your
situation. By using IB_TransForUpdate and doing an Open and Close in your
AfterPost event, it exposed a weakness or gap in my logic that I recently
put in to allow the Activation of the transaction to be deferred until after
the AfterPost event, unless of course you called Activate yourself first.

This is now fixed and will be in the next release (Build 41).

Thanks,
Jason


-----Original Message-----
From: IBObjects@yahoogroups.com [mailto:IBObjects@yahoogroups.com] On Behalf
Of Adrian Wreyford
Sent: 19 February 2012 11:21 AM
To: IBObjects@yahoogroups.com
Subject: [IBO] PessimisticLocking causing problems when posting edits.

Dear Jason,


I'm not sure what is going on, but I am unable to post edits to my queries,
since I updated to the latest IBO.


It appears that PessimisticLocking is the offender, and causing a
SysRollbackRetaining, when it shouldn't be.


Hope you can help.


Thx


Adrian