2012/3/15 Waltênio de Bessa Mendes <walteniobe...@gmail.com> > Dear Simon, > > Thanks for help. > > I created a database named "Biblia" with a table named "LivroDaBiblia". > I tried the shell tool and get the following. >
> *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 > sqlite> .databases > seq name file > > --- --------------- > ---------------------------------------------------------- > > 0 main > > 1 temp > > sqlite>* > > 2012/3/15 Simon Slavin <slav...@bigfraud.org> > >> >> On 15 Mar 2012, at 6:48pm, Waltênio de Bessa Mendes < >> walteniobe...@gmail.com> wrote: >> >> > I need help when receive a message error *"could not prepare statement >> no >> > such table..." * when try >> > execute "*select*" in the code: >> >> Open the database in the shell tool and use '.tables'. >> >> http://www.sqlite.org/sqlite.html >> >> Does it show a table with that name ? If so, try executing the same >> SELECT command in the shell tool. >> >> 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
