CAST was just an attempt to workaround the problem... I just need a way to know what type is "UserCount"... in the query, it is an Integer (because it is a aggregated COUNT function). If SQLite is unable to determine it's type, at least pragma table_info should then get it from a CAST =\
On Sat, Jan 30, 2010 at 2:23 PM, Dan Kennedy <[email protected]> wrote: > > RecNo cid name type notnull dflt_value pk > > ----- --- ------------------ ----------- ------- ---------- -- > > 1 0 ID CHAR(32) 0 (null) 0 > > 2 1 Active BOOLEAN 0 (null) 0 > > 3 2 Name VARCHAR(64) 0 (null) 0 > > 4 3 PasswordExpiration INTEGER 0 (null) 0 > > 5 4 Created DATE 0 (null) 0 > > 6 5 Modified DATE 0 (null) 0 > > 7 6 UserCount 0 (null) 0 > > > > Notice that UserCount (my sub-query) does not return a data type. > > Even with > > CAST(subquery AS INTEGER) does not work =( > > The problem is that CAST(...) casts the type of the value. Does not > affect > for the declared type of the column. > > > > _______________________________________________ > sqlite-users mailing list > [email protected] > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > -- [] Júlio César Ködel G. _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
