[Lazarus] Problem with zeos and sqlite-3

[zeljko]

On Sunday 17 of February 2013 12:00:51 Martin Schreiber wrote:
> On Sunday 17 February 2013 10:31:04 zeljko wrote:
> > > 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.
> 
> "
> CREATE VIEW "testview" AS select * ,cast(0 as integer) as nullint from
> table1 "
> And then
> "
> select * from testview
> "
> in SQL property of tmsesqlquery returns ftinteger for the nullint field.
> Can you post a simple complete example?

You misunderstood me. I returns ftIntger too when using SELECT, but WHEN using 
PRAGMA table_info('testview'); it does not return integer.
So what returns tmsesqlquery in this case:

CREATE VIEW "testview" AS select * ,cast(0 as integer) as nullint from table1;

PRAGMA table_info('testview');