[Lazarus] Problem with zeos and sqlite-3

Martin Schreiber mse00000 at gmail.com
Sun Feb 17 10:05:56 CET 2013


On Friday 15 February 2013 13:41:23 zeljko wrote:

> Thanks for the idea, sqlite3_column_type does the job, but now I have
> another error ... seem that step() doesn't know anything about some column
> types, even if I call sqlite3_column_type inside step() call I get empty
> column type result.eg. in one CREATE VIEW someview(blabla fields,CAST(0 AS
> INTEGER) AS myintfield, etc etc. ...)
> When I call that view I can see 0 in sqlite3 utility, but zeos returns it
> as empty string ....ahhhhhhh whatta mess.
>
sqlite3_column_type() works for CAST(0 AS INTEGER) too in a select statement, 
just tested with MSEgui git master and Sqlite 3.7.12.1. Is the problem caused 
by VIEW?

Martin




More information about the Lazarus mailing list