Re: [sqlite] How to generate a scheme

mn of the DB, I load the XML file and try to match Structure with sqlite_master + PRAGMA table_info (tableName). Hope that gives you a hint. :) Antoine Caron -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Karl Lautman Sent: October 23, 2008 4:18 PM To: sql

[sqlite] Default Row value

Hi guys, I'm not sure I've posted at all my previous msg so here it is again with few more explanation I'm creating a table using the following : # CREATE TABLE IF NOT EXISTS `test_table` ( `test_field1` INTEGER DEFAULT -1, `test_field2` INTEGER DEFAULT NULL );

[sqlite] defalut value of col

Hi guys, Here's a quick one I'm creating a table using the following : # CREATE TABLE IF NOT EXISTS `test_table` ( `test_field` INT NOT NULL DEFAULT -1 ); # Note the default -1 I then do # PRAGMA table_info (test_table) # i'm

[sqlite] sqlite3_open on non-DB file

Hi guys, 1st I'd like to say I'm pretty new to SQLite, about 1 week. I'm trying to handle correctly the DB opening and here's some question on this. #1 I'm validating the db.sqlite file exist. if it doesn't, it creates it, right ? so right after being created, is the sqlite_master table