On Thursday 14 February 2013 13:48:46 zeljko wrote: > 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. > In MSEgui the field type of ambiguous Sqlite3 columns can be defined by setting the fielddefs datatype. Maybe Zeos has a similar option?
Martin -- _______________________________________________ Lazarus mailing list Lazarus@lists.lazarus.freepascal.org http://lists.lazarus.freepascal.org/mailman/listinfo/lazarus