Thanks. That was the problem. I hope my next questions will be more interesting.
----- Original Message ----- From: "Dennis Cote" <[EMAIL PROTECTED]> To: "General Discussion of SQLite Database" <[email protected]> Sent: Wednesday, March 05, 2008 10:04 PM Subject: Re: [sqlite] A beginner question > Aharon (Rony) Shapira wrote: >> I am running under Windows. >> Downloaded sqlite-3_5_6.zip to access and modify the data bases. >> After unzipping I got sqlite3.exe. I run it and I cannot create a >> database. >> Strangely enough I can create a table which stays on until I quit. >> >> I guess that the problem is that the >sqlite3 test.db commands does >> nothing. >> > > Aharon, > > You need to specify the database filename on the command line when you > start sqlite3, not at the sqlite prompt presented when sqlite3 is > waiting for input. > > C:\Documents and Settings\DennisC>sqlite3 test.db > SQLite version 3.5.6 > Enter ".help" for instructions > sqlite> create table t(a,b); > sqlite> .quit > > C:\Documents and Settings\DennisC> > > If you don't specify a filename on the command line sqlite3 uses an in > memory database which is lost when you exit with the .quit command. > > HTH > Dennis Cote > _______________________________________________ > sqlite-users mailing list > [email protected] > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
