Updating a Read-only Dataset
From InterBase
Go Up to Working with Cached Updates
To manually update a read-only dataset:
- Add a
TIBUpdateSQL
component to the data module in your application. - Set the dataset component’s
UpdateObject
property to the name of theTIBUpdateSQL
component in the data module. - Enter the SQL update statement for the result set to the update component’s
ModifySQL
,InsertSQL
,DeleteSQL
, orRefreshSQL
properties, or use the Update SQL editor. - Close the dataset.
- Set the dataset component’s
CachedUpdates
property toTrue
. - Reopen the dataset.
In many circumstances, you may also want to write an OnUpdateRecord
event handler for the dataset.