Icon View Incident Report

Serious Serious
Reported By: Lawrence Lustig
Reported On: 2/1/1999
For: Version 1.09 Build 1
# 273 Non-Optimized Where Clause in SQL SELECT Statement Causing an Access Violation

When last line is changed to liik like the following:
then I try to open the query, Delphi goes into loopy land and I eventually have to use Close Program to kill it. There is occasional disk access. There are only four reccords in each table. Sometimes I get AVs before it fades out, sometimes not. I also tried replacing the "=" with "LIKE" with the same results. I tried using double quotes, and get repeated AVs in DBISAMDB..BPL, but the program stays alive.

Comments Comments
The cause behind this was that the optimization functionality was selecting an index when it shouldn't have been, thus when the actual filtering was done the filter functionality would try to use and index that it shouldn't have. The symptoms of this problem range from wrong results to AVs.

Resolution Resolution
Fixed Problem on 2/1/1999 in version 1.10 build 1