You're asking for the column type, not the value. If you open the database with sqlite3 there is a command that you can use that shows the SQL commands that created the table. The .help functionality is very descriptive though the actual command escapes me at the moment.
Hope this helps ------Original Message------ From: Merv Sender: [EMAIL PROTECTED] To: sqlite-users@sqlite.org ReplyTo: General Discussion of SQLite Database Sent: Oct 6, 2008 22:57 Subject: [sqlite] Column values 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. Have a super one! Merv _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users Timothy A. Sawyer, CISSP Managing Director MBD Solutions Phone: (603) 546-7132 Web: http://www.mybowlingdiary.com Email: [EMAIL PROTECTED] _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
