Icon View Incident Report

Serious Serious
Reported By: Manfred Wekwerth
Reported On: 11/9/2000
For: Version 2.04 Build 1
# 655 Executing a Filter or SQL Where Condition with >= and <= Range Comparisons Doesn't Work Properly

Executing an optimized filter or SQL statement with a where condition that contains >= and <= comparisons on the same value results in the value not being found, even when it exists. This occurs with the German language driver, but not with the ANSI Standard language driver. If the optimized filter or SQL statement's where condition uses the = operator, the query or filter returns the correct results.

{ This query does not return any records }

SELECT * FROM country WHERE Name >= 'Zurich' AND Name <= 'Zurich'

{ This query works properly }

SELECT * FROM country WHERE Name = 'Zurich'

Resolution Resolution
Fixed Problem on 11/12/2000 in version 2.05 build 1