Specifies the update object component used to update a read-only result set.
Syntax:
property UpdateObject: TDataSetUpdateObject;
Description:
Use UpdateObject to specify the TMySQLUpdateSQL component to use in an application that must be able to update a read-only result set.
MySQL always attempts to provide an updatable, 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 property can be used to specify a TMySQLUpdateSQL component that performs updates as a separate transaction that is transparent to the application.
See also: TMySQLUpdateSQL component