Icon View Incident Report

Serious Serious
Reported By: Franz Ehrenhuber
Reported On: 4/16/1999
For: Version 1.13 Build 1
# 413 The SQL IN Operator is Not Working Properly for International Settings and Integers

The IN()-Clause is comparing against an INTEGER-Field so it does not work here for more than one Integer-number.

Select * from test where id IN (1,2,3)

I get an error in DBSYS utilty -> '1,2,3' is not a valid floating point value but the field id is of type integer.

Comments Comments
This problem was caused by the internal SQL parsing engine in DBISAM using the global DecimalSeparator variable in Delphi to identify the decimal point. This would cause the parsing engine to think that the commas in the IN operator argument were decimal points.

Resolution Resolution
Fixed Problem on 4/23/1999 in version 1.14 build 1