Connection to Database on a Palm

[Peter F Jones]

I want to have a database on my Palm which is linked to one on my PC, both showing the same data. Is there a program which runs on the Palm OS V 5.2.1 which will connect (using the "conduit"). The PC is running XP. I use Open Office.

Peter Jones

[Villeroy]

1. You need an application for the Palm platform. OpenOffice.org can not run on such devices.
2. You want to access some unspecific type of database sitting on a PC. Unfortunately, OOo does not provide a true database application, one that could serve data to the outside world. OOo Base is designed to serve data the other way round: from existing databases in the outside world to office documents.
Therefore your problem is unrelated to OpenOffic.org

[Peter F Jones]

Thanks for the reply.

I had not realised that Base's function is to convey outside data to OO software. I have been reading various tutorials and wiki's but none have made this clear. I find this somewhat confusing.

Just to make it clear. Palm has an Address List. So what I should is to CSV it into a Base Table and then proceed from there with all the facilities - Forms, Queries etc. Then I can use the addresses to write letters using Write.

If I want to use Relational Database facilites for any reason I must obtain a Relational Database. Presumably I CSV its Tables into Base Tables.

Peter

[Villeroy]

You may be able to connect to the address list when you mount its file system on the PC and if you know something about the type of database. For instance, it could be SQLite to wrap all the tables of addresses, persons, categories and stuff into a relational database.
dBase tables (*.dbf) are still very common for file based, slim databases.
Whatever it is, there may be some database driver availlable from the Palm vendor.
Yes, you may be able to edit CSV using Base's default database enginge HSQLDB as documented in http://hsqldb.org/doc/guide/ch06.html and demonstrated in http://user.services.openoffice.org/en/ ... 75&t=23727 (files #1 and #2).
This would require some tool to keep the Palm book in sync with the text file(s) or manual export and import from time to time.