View Incident Report

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

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

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

More Support Options

Search Incident Reports

Support Forums

Frequently Asked Questions

Technical Bulletins

Technical Articles

Product Manuals

Roadmap