Am 01.02.24 um 11:40 schrieb LacaK via lazarus:
If i execute: "SELECT CAST(AVG(km_gelaufen) *AS REAL*) FROM
laufdaten" the known problem of integer only shows up again.
BUT:
If i execute this "SELECT CAST(AVG(km_gelaufen) AS REAL) FROM
laufdaten " in SQliteStudio it works as it should.
Ok then it is clear that SQLite produces result as expected
Is DBgrid or Zeos Access components the culpit? I don't know.
Do you use Zeos components not SQLdb (TSQLQuery)?
Can you test datatype of TField created at runtime?
For example place somewhere after dataset is Open-ed something like:
ShowMessage(Fieldtypenames[Query1.Fields[0].DataType]);
L.
I am happy with the result i get ... no more searching needed, see also
last post of Michael van Cannyet
--
_______________________________________________
lazarus mailing list
lazarus@lists.lazarus-ide.org
https://lists.lazarus-ide.org/listinfo/lazarus
