Updating a Read-only Dataset

Go Up to Working with Cached Updates

To manually update a read-only dataset:

1. Add a TIBUpdateSQL component to the data module in your application.
2. Set the dataset component’s UpdateObject property to the name of the TIBUpdateSQL component in the data module.
3. Enter the SQL update statement for the result set to the update component’s ModifySQL, InsertSQL, DeleteSQL, or RefreshSQL properties, or use the Update SQL editor.
4. Close the dataset.
5. Set the dataset component’s CachedUpdates property to True.
6. Reopen the dataset.

In many circumstances, you may also want to write an OnUpdateRecord event handler for the dataset.

Advance To:

• Controlling the Update Process