Re: [sqlite] cast(count(1) as integer) result is text?

2011-01-24 Thread Vannus
Ok, i think i've found my/sqlite problem sqlite_column_decltype and sqlite_column_type are both returning null, so zeos (and presumably sql express) don't know which type to request from http://www.sqlite.org/c3ref/column_decltype.html http://www.sqlite.org/c3ref/column_decltype.htmlIf this

Re: [sqlite] cast(count(1) as integer) result is text?

2011-01-13 Thread Vannus
(missed your message somehow) All 3 return integer in sqlite express (which is good), but zeos doesn't like typeof(). On 6 January 2011 09:12, Simon Slavin slav...@bigfraud.org wrote: On 6 Jan 2011, at 4:00am, Vannus wrote: Using both ZeosLib and SQLite Expert the SubTotal (and count if