[Lazarus] Problem with zeos and sqlite-3

zeljko zeljko at holobit.net
Thu Feb 14 13:48:46 CET 2013


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




More information about the Lazarus mailing list