Thread: sqlite3
View Single Post
bizshop's Avatar
Posts: 98 | Thanked: 8 times | Joined on Apr 2007 @ Port Angeles, WA
#5
I still think you are querying the wrong thing.. You cannot " Select from" a database, you must select from a table. Unless you named both the table and the database by the same name (not a good idea IMHO).

In your example, you used 'select * from main.poi;' Main is just a namr/pointer to tjhe db file. So the queruy should be either 'select * from sometable' or 'select * from poi.sometable'