DAC for MySQL

TMySQLUpdateSQL.Methods.Apply

Previous Next

Sets the parameters for a specified SQL statement type, and executes the resulting statement.

Syntax:

procedure Apply(UpdateKind: TUpdateKind);

Description:

Call Apply to set parameters for an SQL statement and execute it to update a record. UpdateKind indicates which SQL statement to bind and execute, and can be one of the following values:

ValueMeaning
ukDeleteBind and execute the SQL statement in the DeleteSQL property
ukInsertBind and execute the SQL statement in the InsertSQL property
ukModifyBind and execute the SQL statement in the ModifySQL property

Apply is primarily intended for manually executing UPDATE statements from an OnUpdateRecord event handler.

If an SQL statement does not contain parameters, it is more efficient to call ExecSQL instead of Apply.