Icon SetParams Method

procedure SetParams(UpdateKind: TUpdateKind)

Call the SetParams method to bind any parameters in an SQL statement associated with the update object prior to executing the statement. Parameters are indicated in an SQL statement by a colon. Except for the leading colon in the parameter name, the parameter name must exactly match the name of an existing field name for the source table.

Information Parameter names can be prefaced by the "OLD_" prefix. If so, the old value of the field is used to perform the update instead of any updates in the cache.
Image