Icon View Incident Report

Serious Serious
Reported By: Tiago Ameller
Reported On: 11/3/2000
For: Version 2.04 Build 1
# 651 Using a Numeric in SQL BETWEEN that is Greater Than the Range of a SmallInt Causes Incorrect Results

In SQL or Filter, "MySmallIntField BETWEEN 1 AND 99999" always is false, despite of correct values in that range in MySmallIntField. The cause is 99999 is beyond the limits of smallint type.

Resolution Resolution
Fixed Problem on 4/3/2005 in version 4.19 build 1