Dear Simon, I am trying other ways. To learn about command line shell I created the following example: * SQLite version 3.7.10 2012-01-16 13:28:40 Enter ".help" for instructions Enter SQL statements terminated with a ";" sqlite> sqlite3 alphaDB ...> create table contact(name TEXT, city TEXT); Error: near "sqlite3": syntax error sqlite>*
What is wrong? It's like the documentation teachs. 2012/3/15 Simon Slavin <slav...@bigfraud.org> > > On 15 Mar 2012, at 7:11pm, Waltênio de Bessa Mendes < > walteniobe...@gmail.com> wrote: > > >> *SQLite version 3.7.10 2012-01-16 13:28:40 > >> Enter ".help" for instructions > >> Enter SQL statements terminated with a ";" > >> sqlite> $ sqlite3 Biblia > >> ...> ; > >> Error: unrecognized token: "$" > >> sqlite> .tables > >> sqlite> select * from LivroDaBilia; > >> Error: no such table: LivroDaBilia > > The 'sqlite3 <filename>' command goes to your shell. It's not typed into > the shell tool, it's used to start the shell tool and tell it what file to > use. > > I agree with Michael. You're telling your application to open the wrong > file. It's creating a new blank database with no tables in. Which > explains your error message. > > Simon. > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
