On 4/25/05, Griggs, Donald wrote: > Regarding: "I have an SQLite database with 2 columns and 66,000+ rows > that I would like to use on a Palm Tungsten T3." > > I googled up the following. > http://www.jpilot.org/pipermail/jpilot/2002-November/001121.html > It implies that comma-delimited data is importable to the pilot. > > (You can use the command line utility's commands of > .mode csv > .output filename > select * from tablename; > commands to produce such a file) > > Does this solve your problem?
I wish it did. Nice try, though. ;-) The problem is that PilotSQL doesn't have an "Open..." menu item for choosing a file with SQL statements, the only thing I can do is to choose a [binary] database that it has created and put on the "filesystem". The database is the usual SQLite database with a small binary header with information about type and creator. I have tried by various means to create such a header, so far to no avail. Cheers, -- Klaus Alexander Seistrup Magnetic Ink · Copenhagen · Denmark http://magnetic-ink.dk/
