[Lazarus] Problem with zeos and sqlite-3

Martin Schreiber mse00000 at gmail.com
Thu Feb 14 16:19:05 CET 2013


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




More information about the Lazarus mailing list