Re: create SQLite database problems

I copied your code, changed the path to the database file (your home directory doesn't exist on my machine) and it ran just fine. I then connected to the database via sqlite3 and both the .tables and .schema commands returned what I would expect (namely the list of tables and their definitions).

What command are you using to connect to the database? If you're not targeting the specific database you created, sqlite3 will create a new database and it would indeed be empty. Do you still find a lack of tables & schema when connecting as such: sqlite3 /home/user/bmcclintock/code_review.db?

Comment on Re: create SQLite database problems Select or Download Code

Replies are listed 'Best First'.
Re^2: create SQLite database problems by fionbarr (Friar) on Mar 06, 2012 at 19:51 UTC
there is a connect routine in the code sample I provided.	[reply]
Re^3: create SQLite database problems by chilledham (Friar) on Mar 06, 2012 at 19:55 UTC
I am unclear on what you mean by "when I go to the SQLite3 procedure". Can you expand on that, please? In my example, after the perl script runs, I used the sqlite3 command line tool to connect to the database that was created. That's where I saw the tables and schema.	[reply]
Re^4: create SQLite database problems by fionbarr (Friar) on Mar 06, 2012 at 20:03 UTC
sorry, I was not clear...I meant the sqlite3 command line tool.	[reply]
Re^5: create SQLite database problems by chilledham (Friar) on Mar 06, 2012 at 20:10 UTC