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

Reply via email to