---In IBObjects@yahoogroups.com, <ibobjects@yahoogroups.com> wrote:

Ok, I'll have to look into this in more detail. It may be holding the lock because there are other things going on that prevent it from doing a commit of that transactions. It may also just be keeping it longer than necessary. I'll write up a regression test for this area as I want it to be pinned down solid. And, I'll try and slip a fix into this pending release as I consider this a fairly serious issue.

 

Thanks,

Jason

---

From: IBObjects@yahoogroups.com [mailto:IBObjects@yahoogroups.com] On Behalf Of sv@...
Sent: Friday, October 4, 2013 1:05 AM
To: IBObjects@yahoogroups.com
Subject: RE: RE: [IBO] Dataset.Cancel during update query keeps record locked

That's right, both are turned on 

---In IBObjects@yahoogroups.com, <ibobjects@yahoogroups.com> wrote:

Are you using pessimistic locking?

Are you using AutoCommit set to true?

 

Thanks,

Jason

 

---

From: IBObjects@yahoogroups.com [mailto:IBObjects@yahoogroups.com] On Behalf Of sv@...
Sent: Thursday, October 3, 2013 8:36 AM
To: IBObjects@yahoogroups.com
Subject: [IBO] Dataset.Cancel during update query keeps record locked

Hi, 

When a user wants to cancel a record update of a dataset, our application calls the Dataset.Cancel.

But by doing so, the record remains locked.

What's the right way to implement this functionality?

Many thanks in advance!