EPUB | CHM | PDF

TMySQLUpdateSQL.Methods.Apply

Top 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:

ukDelete

Bind and execute the SQL statement in the DeleteSQL property

ukInsert

Bind and execute the SQL statement in the InsertSQL property

ukModify

Bind and execute the SQL statement in the ModifySQL property

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

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