[Lazarus] Problem with zeos and sqlite-3

[Martin Schreiber]

On Sunday 17 February 2013 12:17:24 zeljko wrote:
>
> 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');

You should use sqlite3_column_type() instead of PRAGMA table_info().

Martin