RE: [sqlite] pragma table_info not working on empty table

2007-01-24 Thread RB Smissaert
] pragma table_info not working on empty table I'm not sure if this applies here, but you could try calling this first: PRAGMA empty_result_callbacks = true; -- Eric Pankoke Founder / Lead Developer Point Of Light Software http://www.polsoftware.com/ -- Original me

Re: [sqlite] pragma table_info not working on empty table

2007-01-24 Thread epankoke
I'm not sure if this applies here, but you could try calling this first: PRAGMA empty_result_callbacks = true; -- Eric Pankoke Founder / Lead Developer Point Of Light Software http://www.polsoftware.com/ -- Original message -- From: "RB Smissaert" <[EMAIL PROTECT

[sqlite] pragma table_info not working on empty table

2007-01-24 Thread RB Smissaert
It just looks that this pragma won't give me the fields and data types if the table has no rows yet, but was just created. Is this indeed so and if so is there a way round it? I am trying to avoid parsing sqlite_master as I used to do that and using this pragma is a much cleaner way to do this. Tha