[Lazarus] Problem with zeos and sqlite-3

[zeljko]

Hi,
When using eg. sum(somecolumn) AS sum1, sum(somecolumn2) AS sum2 sqlite 
returns (zeos recognizes) result columns as string not as float.
I've tried CAST(sum(somecolumn) AS REAL) AS sum1 but have same problem.
If I use pure data from table (eg. item INTEGER,value float) then results are 
ok.

I know that sqlite3_column_type() is tricky about correct results, but asking 
if someone have solution for this.

Anyone ?

zeljko