Skip to main content

This is documentation for Caché & Ensemble. See the InterSystems IRIS version of this content.

For information on migrating to InterSystems IRIS, see How to Migrate to InterSystems IRIS, available on the WRC Distributions page (login required).

Preparing a CacheDataAdapter: Overview

A CacheDataAdapter connects a DataSet with a data source. To initialize a CacheDataAdapter you must do the following:

  • Initialize the adapter with the SQL SELECT command. The adapter fills the data set based on this command.

  • Create CacheCommand objects for each of the SQL commands that the adapter supports. In this case, the adapter supports INSERT, UPDATE, and DELETE.

  • For each CacheCommand object, create CacheParameter objects to represent the parameters in its SQL. Add the CacheParameter objects to the CacheCommand objects.