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 following the example at http://sqlite.org/sqlite.html (substituting testdatabase for ex1) and my experiences seem to deviate from what I would expect. Also, I tried this, per your comment about needing a table first... --- SQLite version 3.3.17 Enter ".help" for instructions sqlite> sqlite3 testdatabase //hard return ...> create table tbl1(one varchar(10), two smallint); //hard return SQL error: near "sqlite3": syntax error sqlite> --- I also continued with an 'insert' statement, before a semicolon, but to no avail. Is there a SQLite newbie group / further resource you'd recommend, I hate wasting people's time. On Tue, 5 Jun 2007 13:54:50 -0400, "Igor Tandetnik" <[EMAIL PROTECTED]> said: > 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. > > > However, if I create a sqlite database with TkSQLite, sqlite.exe can > > 'attach' to that test database, and, using the sqlite.exe command > > '.databases', I can see that database, however, using '.tables' > > doesn't show me the test table. > > .tables command only shows tables in the main database. To see tables in > attached databases, use > > select * from db.sqlite_master; > > where 'db' is the name under which you attached the database. > > Igor Tandetnik > > > ----------------------------------------------------------------------------- > To unsubscribe, send email to [EMAIL PROTECTED] > ----------------------------------------------------------------------------- > -- [EMAIL PROTECTED] ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
