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] -----------------------------------------------------------------------------