Subject Re: [IBO] Problem with pessimistic locking
Author Helen Borrie (TeamIBO)
At 10:02 PM 30-01-02 +0100, Helmut wrote:
>Since I updated to the latest release of IBO, Pessimisticlocking
>doesn't work any more, as expected. I cannot realy say, since which
>release, but now it is not working. When I set a record in edit mode
>and then do the same from second application, it doesn't raise a
>lockexception. When I try to save, then the lockexception is raised.
>I didn't change anything in my application. Just recompiled with
>latest IBO. So something must have been changed in IBO.
>Could anybody help me with this problem?

The immediate thing I can think of is that you have somehow changed the LockWait setting of your transaction (or database object) to true. If so, PessimisticLocking is disabled.

If this isn't your issue, then another place to look will be to test (in your code, or via the debugger) whether the first dataset really did go into Edit mode. If you establish that it did, in fact, then test whether the second dataset succeeded in going into Edit mode.

Also, look at what the SQL Monitor is telling you.

After that, if you still don't find anything, make up a small project that demonstrates the problem, zip it up, post it to the Files area of the list, and post a list message telling us what it is for.

Helen Borrie (TeamIBO Support)

** Please don't email your support questions privately **
Ask on the list and everyone benefits
Don't forget the IB Objects online FAQ - link from any page at