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