Icon View Incident Report

Serious Serious
Reported By: Hendrik Steyn
Reported On: 10/15/2002
For: Version 3.18 Build 1
# 1247 Executing a Non-Optimized Filter or SQL WHERE Clause with String Comparison Returns Incorrect Result

The filter does not work properly.

Use the following filter in DBSYS on a string field called piecemain. 
 There is no index on this field.

piecemain="1234"

It returns all the "1" records.



Resolution Resolution
Fixed Problem on 10/15/2002 in version 3.19 build 1
Image