RE: [sqlite] pragma table_info not working on empty table
I think the trouble was somewhere else and it looks that pragma works fine Even with an empty table. Thanks for the tip in any case. RBS -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: 24 January 2007 22:56 To: sqlite-users@sqlite.org Subject: Re: [sqlite] 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 message -- From: "RB Smissaert" <[EMAIL PROTECTED]> > 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. > Thanks for any advice. > > RBS > > > > > - > To unsubscribe, send email to [EMAIL PROTECTED] > - > - To unsubscribe, send email to [EMAIL PROTECTED] - - To unsubscribe, send email to [EMAIL PROTECTED] -
Re: [sqlite] 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 message -- From: "RB Smissaert" <[EMAIL PROTECTED]> > 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. > Thanks for any advice. > > RBS > > > > > - > To unsubscribe, send email to [EMAIL PROTECTED] > - > - To unsubscribe, send email to [EMAIL PROTECTED] -
[sqlite] pragma table_info not working on empty table
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. Thanks for any advice. RBS - To unsubscribe, send email to [EMAIL PROTECTED] -