Ah yes! I tried a dos prompt last night, but it wouldn't work... didn't like the directory or something odd. I moved the sqlite3 program to the C:\ dir and it worked.But now I have no idea where it created the test.db! Haha...

Thank you for your help!
Clara



Trevor Talbot wrote:
On 11/18/06, Clara Kinner <[EMAIL PROTECTED]> wrote:
I've just started using SQL, and was recommended this program by a
co-worker... so I tried the sqlite3 test.db command to start up my new
DB, but when I hit enter, it returns with a ...> prompt, so when enter,
or end test.db with a ";", I get a message reading:

SQL Error: near "sqlite3": syntax error

It sounds as though you opened the sqlite3 shell, and tried to enter
that command at its prompt.  That command is meant to be entered at
your OS's command prompt instead -- it starts the sqlite3 shell with
that database filename as a parameter.

-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------




-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------

Reply via email to