My mistake - I meant: sqlite> .schema
if sqlite is telling you that the table doesn't exist, the .schema command should tell you what tables exist. RW Ron Wilson, Engineering Project Lead (o) 434.455.6453, (m) 434.851.1612, www.harris.com HARRIS CORPORATION | RF Communications Division assuredcommunications(tm) > -----Original Message----- > From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users- > boun...@sqlite.org] On Behalf Of dave lilley > Sent: Monday, December 07, 2009 2:06 AM > To: General Discussion of SQLite Database > Subject: Re: [sqlite] Sqlite3.exe command line tool - winXP > > > Well I've tried the following > > sqlite3 <path to the DB> dbfile > I get put to the command line. > > typed in the following and below is the results. > > sqlite> .show > echo: off > explain: on > headers: on > mode: explain > nullvalue: "" > output: stdout > separator: "|" > width: 4 13 4 4 4 13 2 13 > sqlite> .schema ?table? accounts; > sqlite> .schema ?accounts?; > sqlite> > > So I don't know if it's me not understanding the syntax or not. > > I have 5 tables one of them *is* accounts. > > thanks for your reply. > > > 2009/12/7 Wilson, Ronald <rwils...@harris.com> > > > what tables do you have? > > sqlite> schema; > > > > from my mobile 434.851.1612 > > > > On Dec 5, 2009, at 11:31 PM, "dave lilley" <dgl...@gmail.com> wrote: > > > > > > > > I have been trying to (without much joy) get a list of rows from a > > > table > > > within an sqlite3 DB. > > > > > > I've been starting from the CMD prompt sqite3 <DB filename here> > > > dropping into sqlite3 cmd prompt i type in.... > > > > > > sqlite> select * from accounts; > > > SQL error: no such table: accounts > > > sqlite> > > > > > > Now I've used SQLite Database manager 3.1 to create the tables (at > > > least 5 > > > in the one db) and have been able to access the tables until i > > > started to > > > entry text for a blob field and now the DB manager falls over! > > > > > > I am using ruby 1.8.6 as my dev language an suppose i should put it > > > to that > > > community BUT my issue of not being able to generate a list of data > > > from an > > > sql statement when i know the names of the tables does belong here. > > > > > > any help would be appreciated. > > > > > > dave. > > > _______________________________________________ > > > 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 > > > _______________________________________________ > 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
