Re: [sqlite] Column values

2008-10-07 Thread Merv
Thank you. You are right, it is type I am looking for. Have a super one! Merv Timothy A. Sawyer wrote: > 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 f

Re: [sqlite] Column values

2008-10-06 Thread Jay A. Kreibich
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

Re: [sqlite] Column values

2008-10-06 Thread P Kishor
On 10/6/08, Merv <[EMAIL PROTECTED]> wrote: > 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. typeof(X) http://www.sqlite.org/lang_corefunc.html > Have a super one! > > Merv > __

Re: [sqlite] Column values

2008-10-06 Thread Timothy A. Sawyer
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 --O