Icon View Incident Report

Serious Serious
Reported By: Andrew Lyric
Reported On: 12/8/2007
For: Version 1.06 Build 1
# 2496 Editing a Row in a Sensitive Result Set So That It Falls Out of the WHERE Clause Causes Locate Issue

The problem is that Locate will return True after searching for a record that has been edited in such a way that it no longer would be "in" the query.

Query.SQL = 'SELECT * FROM tablename WHERE Status=3'
Edit makes tablename.Status := 2;
A Locate will return True, but the cursor is not on that record.



Resolution Resolution
Fixed Problem on 12/9/2007 in version 1.07 build 1


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

Image