|
2007-09-29
, 05:00
|
|
Posts: 98 |
Thanked: 8 times |
Joined on Apr 2007
@ Port Angeles, WA
|
#2
|
|
2007-09-29
, 07:34
|
|
Posts: 299 |
Thanked: 168 times |
Joined on Jun 2006
@ Wales UK
|
#3
|
|
2007-09-30
, 01:08
|
|
Posts: 531 |
Thanked: 79 times |
Joined on Oct 2006
@ This side of insane, that side of genius
|
#4
|
|
2007-09-30
, 05:44
|
|
Posts: 98 |
Thanked: 8 times |
Joined on Apr 2007
@ Port Angeles, WA
|
#5
|
|
2007-10-01
, 20:22
|
|
Posts: 299 |
Thanked: 168 times |
Joined on Jun 2006
@ Wales UK
|
#6
|
|
2007-10-05
, 02:08
|
|
Posts: 531 |
Thanked: 79 times |
Joined on Oct 2006
@ This side of insane, that side of genius
|
#7
|
|
2007-10-05
, 05:58
|
|
Posts: 299 |
Thanked: 168 times |
Joined on Jun 2006
@ Wales UK
|
#8
|
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?
Nokia n800
OS 2008
Pharos iGPS 360-BT
ElmScan 5 BlueTooth
BlackBerry Bold (9000)
AT&T Wireless