Reported By: Stefano Monterisi Reported On: 10/3/2001 For: Version 3.02 Build 1
# 907Floating-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
CommentsDBISAM was not converting the text properly from ANSI format into a usable format for the internal StrToFloat calls.
ResolutionFixed Problem on 10/3/2001 in version 3.03 build 1