Reported By: Franz Ehrenhuber Reported On: 4/16/1999 For: Version 1.13 Build 1
# 413The 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.
CommentsThis 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.
ResolutionFixed Problem on 4/23/1999 in version 1.14 build 1