Icon View Incident Report

Serious Serious
Reported By: Stefano Monterisi
Reported On: 10/3/2001
For: Version 3.02 Build 1
# 907 Floating-Point Constants Not Working in SQL and Filter Expressions in Non-English Windows Locales

I have noted this difference from 3.01 to 3.02 in Dbisam's queries: I use the following query for creating canned queries with a temporary field that I use for calculating a running sum while traversing the query after generation. With Dbisam 3.01 and prior '0.00 as tempfield' create a new float field into dataset structure. Now I have an error on query : "constant '0.00' is not a valid number in
source column expression'.

Select xfield, yfield, 0.00 as tempfield from my table

Comments Comments
DBISAM was not converting the text properly from ANSI format into a usable format for the internal StrToFloat calls.

Resolution Resolution
Fixed Problem on 10/3/2001 in version 3.03 build 1