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
