Cancel on a dataset lets a database lock

[planas]

Hello,

I use an oracle dataset with these properties :
- CommitOnPost False
- LockingMode lmLockImmediate

So when i edit the oracle dataset a lock is set. But if i cancel it the lock is always here.

JP

 

[Marco Kalter]

That is correct. The lock occurs when you start to edit the record. When this operation is canceled, the lock cannot be cancelled, because a rollback could possibly corrupt the current transaction.

------------------
Marco Kalter
Allround Automations

 

[planas]

Hello,

I agree with you. Another solution is to set a savepoint before locking and then after cancel execute a rollback to this savepoint.

JP