On Wed, Jul 07, 2010 at 12:32:53PM +0100, Andrew Wood scratched on the wall: > Is there not just a function which will take the index of a column and > return its declared type?
Not in the general case. sqlite3_column_decltype() will do it for SELECT statements, but only if the result-set column is a direct column reference, and only if SQLite is compiled to handle meta-data. Declared types are fairly unimportant in SQLite. They don't mean much. Most applications never need to deal with them. -j > On 07/07/10 04:41, Jay A. Kreibich wrote: > > On Tue, Jul 06, 2010 at 11:27:09PM +0100, Andrew Wood scratched on the wall: > > > >> How can I find out the declared type of a column. > >> > > If you just want to know the declared type of a column you already > > know about, it use "PRAGMA table_info". > > > > http://www.sqlite.org/pragma.html > > > > -j -- Jay A. Kreibich < J A Y @ K R E I B I.C H > "Intelligence is like underwear: it is important that you have it, but showing it to the wrong people has the tendency to make them feel uncomfortable." -- Angela Johnson _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
