Reported By: Andrew Lyric Reported On: 12/8/2007 For: Version 1.06 Build 1
# 2496Editing 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.
ResolutionFixed Problem on 12/9/2007 in version 1.07 build 1
Products AffectedElevateDB 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