On Wed, May 22, 2013 at 10:30 AM, Igor Tandetnik <i...@tandetnik.org> wrote: > On 5/22/2013 8:58 AM, Sean Dzafovic wrote: >> >> I downloaded the shell and the dll from the sqlite.org site. I put the >> .dll in the windows/system32 folder. However, when I try to create a >> test db using the command "sqlite3 test.db" as per the example, I get >> "Error: near "sqlite3" :syntax error. >> >> What am I doing wrong? > > > You are running this command on sqlite3 command line (do you see "sqlite3>" > prompt?) Instead, you should run this command on Windows command line (Start >> Run > cmd), in order to start sqlite3 shell with a given DB file as a > parameter.
Tried it with the shell on my desktop and got the error. Moved it to the system32 folder along with the .dll and got the same error. (Both of these by clicking on the icon). Same when I tried using the Windows command line. Either way when I open the shell it gives me a sqlite> prompt, not sqlite3> _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users