I've named it db.s3db, run the shell, type sqlite3 db, then select * from songs; and it gives the error "Error: near "sqlite3": syntax error.
On Tue, Nov 12, 2013 at 1:26 PM, Simon Slavin <slav...@bigfraud.org> wrote: > > On 12 Nov 2013, at 1:50am, SongbookDB <shaun_thom...@songbookdb.com> > wrote: > > > I've downloaded and run the shell tool - re opening a database, where do > > base dir paths start from? I have the sqlite3.exe in a dir called test in > > my downloads folder, and the test database is called db.sbdb - typing > > sqlite3 db.sbdb doesn't open it. > > Paths start from your current directory. The one you'd see if you typed > DIR or ls. > > Or you could try specifying a full path. > > Simon. > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > -- Shaun Thomson Owner - SongbookDB _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users