Is not a valid floating point value

[mierlp]

Hi,

 

My mySQL table contains a field COST of the type FLOAT (length 6 and decimals 2)
The default value for this field is NULL. Even when i make ik 0.00 i still got the errors

 

I use a UniDBFormattedNumberEdit for this field and set
- decimalPrecision    = 2

- decimalSeparator   = ,

- thousandSeparator = .

 

When opening the form i got the message 'Is not a valid floating point value'

after that the message 'uniDBGrid: TuniDBGrid: is not a valid floaing point value'

 

 

The uniDBGrid contains only 1 field of type string.

 

Any suggestions ?

 

 

Delphi Tokyo 10.2.2.

uniGui 1.10.0.1472

[Oliver Morsch]

I would use numeric or decimal data type for such a value.