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.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Preview
Unable to display preview. Download preview PDF.
Rights and permissions
Copyright information
© 2001 Rob Tiffany
About this chapter
Cite this chapter
Tiffany, R. (2001). The Pocket SQL Data Manipulation Language. In: Pocket PC Database Development with Embedded Visual Basic. Apress, Berkeley, CA. https://doi.org/10.1007/978-1-4302-1142-6_3
Download citation
DOI: https://doi.org/10.1007/978-1-4302-1142-6_3
Publisher Name: Apress, Berkeley, CA
Print ISBN: 978-1-893115-65-1
Online ISBN: 978-1-4302-1142-6
eBook Packages: Springer Book Archive