I can confirm (FWIW).

I had to go back from 36i to 36d because of this. I did not have the time to even start tracing along as other stuff happened. I've compiled with b41 now and it works!

Hopefully I'll be back on track with the latest builds again now :)

Thanks Adrian and thanks Jason,

/Dany

--- In IBObjects@yahoogroups.com, "IBO Support List" <supportlist@...> wrote:
>
> 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
>