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.
Chapter 5. SQL Databases
In this chapter, we look at several techniques for distributing and manipulating enterprise SQL data on the Palm handheld device. In keeping with the “Zen of Palm,” our aim is to present techniques that provide timely data for the user, not to burden him or her with the complexities of a desktop application.
Our first example shows how to use the AppForge libraries under Windows to prepare relational data for use on the road. We build a simple VB desktop application that uses Active Data Objects (ADO) to create a PDB file from a database query. The database holds thousands of Internet dial-up numbers; the PDB we create contains only those numbers the user wants.
Our second example shows how to use a powerful tool, the AppForge Universal Conduit, to synchronize data between a simple application on the Palm and an SQL database. Our application uses a small database; changes on the Palm device are uploaded to the SQL server, and vice versa. The Universal Conduit allows synchronization without any VB development—quite an accomplishment, considering that we devoted all of Chapter 4 to coding custom conduits.[34]
SQL Publishing
The Palm device is a very good tool for displaying information to the user, provided that the data display is quick and pertinent. The mobile user wants a fraction of the SQL database published to his or her Palm device—just the facts or figures that will be relevant today, not yesterday or next month. This push technology is perfect for ...
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.