Icon View Incident Report

Serious Serious
Reported By: Graeme Cox
Reported On: 9/28/2008
For: Version 2.01 Build 5
# 2784 Using Optimistic Locking Can Cause Row Lock Errors When Updating More than One Row

This issue was introduced in build5. We rolled back to build 4 and no such problem.

1.Optimistic locking is used.
2.There is a TEDBTable object linked to a lookup table in the database that is opened.
3.There is a TClientDataSet object linked to a query which contains a JOIN to the same lookup table.
4.The ClientDataSet values are Posted twice or more.
5.ApplyUpdates is called.

Error EDB_ERROR_CONSTRAINT or EDB_ERROR_LOCKROW occurs on the row that the TEDBTable is currently on.

Resolution Resolution
Fixed Problem on 9/29/2008 in version 2.02 build 1

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