[Lazarus] Problem with zeos and sqlite-3

[zeljko]

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