The Pocket SQL Data Manipulation Language

Abstract

In chapter 2 you learned everything you need to know about building databases, tables, and indexes on the Pocket PC. Now it’s time to learn how to make use of those database objects by working with live data. The SQL Data Manipulation Language (DML) describes how data is inserted, updated, retrieved, and deleted. As you’re accustomed to hearing by now, the Pocket SQL version of the DML is a limited subset of what you’re used to working with on the desktop and the server. The most noticeable limitation is the absence of the UPDATE statement used to modify the values of one or more existing rows in a database. Don’t worry, in Chapter 5 I’ll show you how to perform updates using Recordset objects. There are many more missing SQL statements that I’m sure you’ll feel that you can’t live without, but fortunately, all the basics are covered.