Well, I never did get my project to work on my palm. However I did learn a few things that don't seem to be documented anywhere. If someone with more experience with Java and programming for the palm can comment on my findings, I will truely appreciate it.
1. Using the KVM/Palm Emulator to create databases on your pc doesn't seem to work exactly as documented. First of all, a database file does not get created. This wonderful little file has all sorts of interesting information about your database, like it's name, type, creator, NUMBEROFRECORDS (see a previous post), locationblocks (which contain locationID, uniqueID, and attributes about each of the records), etc.
2. Because this file doesn't exist, (remember this is on your pc) any other program that you write that creates its own database, will write all over your previous database. (what a mess) It doesn't matter that the database name and creatorID are different, since there is no database file.....
3. Database records do get created. They all get created with names like Database_0, Database_1, Database_2, etc. However, addRecord(data) will forever add record Database_65256 (last record in database) and not to the next available spot as I would have expected.(Remember, this is running on your pc.) deleteRecord(int) will delete a record. It is documented to work by tagging the record as deleted and 'moving' it to the end of the database to be used later to sync. On your pc - the record is just gone.
I am seriously thinking about extending this project for my master's thesis. However the Java API for Palm Database programming seems very limited to me with very little documentation concerning differences between running on a pc and a device.
I found a blurb on a palm users group that 3Com/Palm will not guarantee a program will work on their OS unless it is written using CodeWarrior. Anyone know anything about this?
....where ARE my C books?.....
Yes, I am going to redo this using C. The API is much broader and there is much more documentation out in the world about this.
I find it really hard to believe that there is no one on this site that hasn't run into this issue. If anyone has any information at all about this topic, even if it's another question, by all means ask. I would rather program this in my native 'language' (java) than try to think back to my c days...and this discussion would make a good starting point for my research!
PS. If I continue talking to myself, you'll start to think I am crazy.
[This message has been edited by AJ Dussault (edited March 09, 2001).]