On Thursday 14 of February 2013 16:19:05 Martin Schreiber wrote: > 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?
It have, but I'm dynamically creating queries so adding fielddefs manually for each query isn't nice option, anyway thanks for the info. zeljko -- _______________________________________________ Lazarus mailing list [email protected] http://lists.lazarus.freepascal.org/mailman/listinfo/lazarus
