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. -- _______________________________________________ Lazarus mailing list Lazarus@lists.lazarus.freepascal.org http://lists.lazarus.freepascal.org/mailman/listinfo/lazarus