El 31/01/2024 a las 14:32, n Landmesser via lazarus escribió:
An SQL satatement on a float field is displayed as an integer field in
a DBGrid. The fields are created "on the fly" they are not static!
SQL statement is:
"SELECT AVG( km_gelaufen ) FROM laufdaten"
SQL returns the correct value "2,00739263803681" if i copy the value
in DBGrid, but DBGrid itself shows only integer value.
Look the format of the field component.
Is it a TIntegerField? Maybe you selected the wrong field type, it
should be a TFloatField
If it is a TFloatField, look at display format. Maybe you haven't
selected the number of decimal properly.
Any idea how to correct that?
It is a SQlite database.
Info:
Lazarus 3.99 (rev main_3_99-1333-g5c01e6a88e) FPC 3.2.2 x86_64-linux-gtk2
Tipps are welcome ..,
--
Saludos
Santi
--
_______________________________________________
lazarus mailing list
lazarus@lists.lazarus-ide.org
https://lists.lazarus-ide.org/listinfo/lazarus
