i am trying to use sqlite3 command line to look at my poi.db file.

when i issue...

select * from poi;

i only get the prompt back. i invoke sqlite3 from the command line as such...

sqlite3 poi.db

from the dir that the poi.db file resides in. a .databases returns the file as the main database and some temp db, so the db is opened and connected/attached to, or so i think.

i have over 50 poi's in the db, and i am getting nothing back form the select statement, though .schema and .tables comes back with info. is my syntax off or does anyone have an idea?