| Subject | RE: RE: [IBO] Dataset.Cancel during update query keeps record locked |
|---|---|
| Author | IBO Support List |
| Post date | 2013-10-04T16:23:40Z |
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
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!