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.
Universal Conduit
The previous example covered static data, whereas in the following example, data can change on either the Palm or the SQL database. In Chapter 4 we showed how to build a custom conduit to move data between the Palm and the desktop. Here, we show how to configure the AppForge Universal Conduit (UC) to synchronize changes between the PDB files on Palm and a Microsoft SQL server, and how to design around some constraints imposed by the UC.
The UC works with Microsoft Object Database Connector (ODBC) data sources. It has a wizard-like utility for selecting SQL data tables to synchronize. The utility takes care of mapping SQL data fields to the appropriate Palm data types. Like the AppForge Database Converter, which we covered in Chapter 3, the wizard can produce PDB files as well as a VB module with record layouts. We’ll look at how to configure the UC in detail later in this section.
Tip
The UC is only available as a feature of the AppForge Professional edition. You must have the Professional edition to synchronize SQL data using the techniques we cover in this section.
Our example program supports a simple sales application, which is loaded onto a Palm device issued to each member of a sales force. This type of application might be used to sign up customers and take orders. During synchronization, any new data entered in the field is uploaded to the SQL server. At the same time, new product or pricing information is downloaded from the SQL server to the Palm device. ...
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.