Reported By: Joost Pol Reported On: 6/26/2000 For: Version 2.02 Build 1
# 570Parsing of Comma Decimal Separators Not Working Properly in SQL Statements and Filters The parsing of decimal separators in filters and SQL statements was incorrect - only the period (.) was being recognized as a valid decimal separator even if the language settings indicated otherwise.
CommentsDue to this change if you are using language settings that contain a comma (,) as the decimal separator you should make sure to include spaces before and after the required comma separator so that the decimal separator will not be confused with the comma separator. For example, to use floating-point constants in an IN clause when the decimal separator is a comma, you would use the following:
SELECT *
FROM customer
WHERE TaxRate IN (8,5 , 9,0 , 0,0)
ResolutionFixed Problem on 6/28/2000 in version 2.03 build 1