Problem with nonstandard field
Posted: 11.06.2006, 19:04
Problem appears when I use internal functions or expressions and result is a number with decimal separator:
or
After executing I use:
ds.FieldByName('fld').AsFloat
i've get "3.0 is not a valid floating point value" and here is a bug, in some country's decimal separator is '.' in other ',', result of sqlite is always with '.'
Code: Select all
SELECT SUM(1.0) fldCode: Select all
SELECT 1.0+2.0 fldds.FieldByName('fld').AsFloat
i've get "3.0 is not a valid floating point value" and here is a bug, in some country's decimal separator is '.' in other ',', result of sqlite is always with '.'