Specifies the update object component used to update a read-only result set.
property UpdateObject: TDataSetUpdateObject;
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 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 property can be used to specify a TMySQLUpdateSQL component that performs updates as a separate transaction that is transparent to the application.