> 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 sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users