[Lazarus] Problem with zeos and sqlite-3
zeljko
zeljko at holobit.net
Thu Feb 14 16:52:32 CET 2013
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
More information about the Lazarus
mailing list