Working with result sets
Go Up to Working with Queries
By default, the result set returned by a query is read-only. Your application can display field values from the result set in data-aware controls, but users cannot edit those values. To enable editing of a result set, your application must use a
Updating a read-only result set
Applications can update data returned in a read-only result set if they are using cached updates. To update a read-only result set associated with a query component:
- Add a
TIBUpdateSQLcomponent to the data module in your application to essentially give you the ability to post updates to a read-only dataset.
- Enter the SQL update statement for the result set to the
DeleteSQLproperties of the update component. To do this more easily, right-click on the
TIBUpdateSQLcomponent to access the UpdateSQL Editor.