Zeoslib Portal

Using sum(x) or total(x) in a query on integer or float fields always results in the creation of tStringFields in Delphi.

Using the SQLite typeof function shows them to be "real".

I've seen other posts like this, but no solution.

Any help appreciated.

I have the same issue ... what can we do ? thank you!

That's an issue with SQLite, it only has 4 datatypes and to be worst enough, they are interchangeable and not strict typed.