Re: [sqlite] Re: Newbie - can't create database but I can attach

2007-06-05 Thread nvi
Thank you Igor, I appreciate your time! I wasn't specific enough, here's what's happening in my DOS window... --- SQLite version 3.3.17 Enter ".help" for instructions sqlite> sqlite3 testdatabase //hard return ...> ; //hard return SQL error: near "sqlite3": syntax error sqlite> --- I was

[sqlite] Re: Newbie - can't create database but I can attach

2007-06-05 Thread Igor Tandetnik
nvi-yMULe1UMIukeIZ0/[EMAIL PROTECTED] wrote: Hello, thanks in advance, I've tried to answer this through extensive searching. The following syntax does not create a database, e.g.; sqlite> sqlite3 testdatabase SQLite defers creating the database file until you create the first table.