Icon View Incident Report

Serious Serious
Reported By: Fernando Dias
Reported On: 9/7/2008
For: Version 2.01 Build 4
# 2774 Posting Changes to a Row After a Transaction Commit/Rollback Can Cause Row Unlock Error

I tested almost all possible sequences using Edit, Post, StartTransaction and Commit and some of them generate an exception:

"ElevateDB Error #1006 Cannot unlock the row in the table ..."

The problematic sequences are:
- StartTransaction; Edit; Post ; Edit; Commit; Post;
- Edit; StartTransaction; Post ; Edit; Commit; Post;

If you replace Commit with Rollback and/or Post with Cancel the problem is the same.

Comments Comments and Workarounds
The workaround is to make sure that all Post calls happen before a transaction Commit or Rollback when updating rows inside of a transaction.

Resolution Resolution
Fixed Problem on 9/10/2008 in version 2.01 build 5

Products Affected Products Affected
ElevateDB Additional Software and Utilities
ElevateDB DAC Client-Server
ElevateDB DAC Client-Server with Source
ElevateDB DAC Standard
ElevateDB DAC Standard with Source
ElevateDB DAC Trial
ElevateDB VCL Client-Server
ElevateDB VCL Client-Server with Source
ElevateDB VCL Standard
ElevateDB VCL Standard with Source
ElevateDB VCL Trial