April 2002
Intermediate to advanced
440 pages
12h 37m
English
Content preview from Programming Visual Basic for the Palm OSBecome an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.
The AppForge Database Converter
In this chapter, we’ve looked at how to create and manipulate a database programmatically, but we’ve ignored the issue of content—how do you get desktop data into the PDB? Typically, you accomplish this by using the HotSync process, with a custom conduit for your database, or with a conversion program developed specifically for your application.
There is an easier way: the AppForge Database Converter. This is a simple tool that moves existing data from the Windows desktop into Palm databases. This tool will create the PDB, populate its records, and generate VB source code that contains the Creator ID and Type ID, the record schema, and functions to read and write records.
The Database Converter requires its input to be in Microsoft Access format; it translates the internal tables into individual Palm PDB files. This is not as restrictive as it sounds, for it is possible to convert almost any data source into an Access MDB file or link table.[24]
The conversion is an excellent time to think about what information really needs to be transferred. If your Windows desktop database has information that will not be relevant to the user, filter it out before it gets to the Palm device. The more data on the handheld, the slower the handheld will run.
Once the information is in a Microsoft Access database, you must ensure that the tables to be converted to the Palm have supported data types. Table 3-9 shows how each MS Access data type is converted.
Table 3-9. Supported ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access
More than 5,000 organizations count on O’Reilly
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.Julian F.
I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.Addison B.
I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.Amir M.
I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.