[Lazarus] Problem with zeos and sqlite-3

zeljko zeljko at holobit.net
Sun Feb 17 10:31:04 CET 2013


On Sunday 17 of February 2013 10:05:56 Martin Schreiber wrote:
> 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?

Didn't test 3.7, but 3.6.23. As I already mentioned it works ok for select 
,but pragma table_info(''myview') does not work for casts .... returns empty 
type.

z.




More information about the Lazarus mailing list