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