The ADOCE Recordset Object

Abstract

We’ve finally made it to the final building block needed to create database applications on the Pocket PC. SQL DML enables you to build databases and the Connection object enables you to connect to databases, but the Recordset object is definitely where the action is. When you execute a query that returns rows of data, ADOCE packages those rows together in a Recordset object. This Recordset object presents itself to you in the form of a virtual table with a subset of columns and rows that match up with the actual columns and rows found in the database table you’re running a query against. Unfortunately, the ADOCE Recordset object lacks many of the features provided by its desktop and server cousins. You won’t be able to use things like data shaping and disconnected Recordsets, and you won’t have the ability to search within the Recordset and save your records as XML. Don’t panic! You’ll find a way to get along without all those cool features.