Problem with nonstandard field

[maciejkaczkowski]

Problem appears when I use internal functions or expressions and result is a number with decimal separator:

Code: Select all

SELECT SUM(1.0) fld

or

Code: Select all

SELECT 1.0+2.0 fld

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 '.'