Re: create SQLite database problems

[chilledham]

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?

[fionbarr]

there is a connect routine in the code sample I provided.

[chilledham]

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.

[fionbarr]

sorry, I was not clear...I meant the sqlite3 command line tool.