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
