Working with result sets
From InterBase
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 TIBUpdateSQL
component.
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
TIBUpdateSQL
component 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
ModifySQL
,InsertSQL
, orDeleteSQL
properties of the update component. To do this more easily, right-click on theTIBUpdateSQL
component to access the UpdateSQL Editor.