Icon View Incident Report

Serious Serious
Reported By: Joost Pol
Reported On: 6/26/2000
For: Version 2.02 Build 1
# 570 Parsing 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.


Comments Comments
Due 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)


Resolution Resolution
Fixed Problem on 6/28/2000 in version 2.03 build 1
Image