Specifies the update object component used to update a read-only result set.

Syntax:

property UpdateObject: TDataSetUpdateObject;

Description:

Use UpdateObject to specify the TUpdateObject component to use in an application that must be able to update a read-only result set.

PostgreSQL always attempts to provide an updateable, or "live" query result unless an application specifically requests a read-only view of data. In some cases, such as a query made against multiple tables, a live result set cannot be returned. In these cases, UpdateObject can be used to specify a TPSQLUpdateSQL component that performs updates as a separate transaction that is transparent to the application.