Working with Cached Updates
Go Up to Developer's Guide
Cached updates enable you to retrieve data from a database, cache and edit it locally, and then apply the cached updates to the database as a unit. When cached updates are enabled, updates to a dataset (such as posting changes or deleting records) are stored in an internal cache instead of being written directly to the dataset’s underlying table. When changes are complete, your application calls a method that writes the cached changes to the database and clears the cache.
This chapter describes when and how to use cached updates. It also describes the TIBUpdateSQL
component that can be used in conjunction with cached updates to update virtually any dataset, particularly datasets that are not normally updatable.
Topics
- Deciding When to Use Cached Updates
- Using Cached Updates
- Using Update Objects to Update a Dataset
- Updating a Read-only Dataset
- Controlling the Update Process
- Handling Cached Update Errors