On Mon, Oct 06, 2008 at 10:57:22PM -0400, Merv scratched on the wall: > Hi > > Will someone please tell me how I can retrieve the value of a column, > i.e. is if integer or varchar etc. > I am accessing an unknown file.
If you have an unknown SQLite database file you're trying to poke around in, you'll want to take a look at the sqlite_master table. That has all the SQL used to create the parts of the database. Also useful are commands like PRAGMA table_info(<table>). See http://www.sqlite.org/pragma.html#schema Understand, however, that columns don't have "types" in SQLite, but only type affinities. Each individual value in a column can (and does) have its own unique type. -j -- Jay A. Kreibich < J A Y @ K R E I B I.C H > "Our opponent is an alien starship packed with atomic bombs. We have a protractor." "I'll go home and see if I can scrounge up a ruler and a piece of string." --from Anathem by Neal Stephenson _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
