Regarding: Either way when I open the shell it gives me a sqlite> prompt,
not sqlite3>
Yes, I suspect Igor intended
sqlite>
But to his larger point, am I close to correct in replicating your error
below? I strongly suspect you're typing "sqlite3" when you are already
inside the sqlite3 program and getting the sqlite> prompt.
C:\Users\ad>sqlite3
SQLite version 3.7.16.2 2013-04-12 11:52:43
Enter ".help" for instructions
Enter SQL statements terminated with a ";"
sqlite> sqlite3 test.db
...> ;
Error: near "sqlite3": syntax error
sqlite>
The error comes after giving sqlite a semicolon to tell the system you are
finally done with a command.
So be sure that when you get to the windows command line and in your
desired directory, your first command should be:
sqlite3 test.db
Then you should get an sqlite prompt, and should *already* be working in
your new database named test.db
sqlite>
Sorry to waste bits if your problem lies elsewhere,
Donald
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
