IBX.IBUpdateSQL.TIBUpdateSQL.SetParams

• Up to Parent: TIBUpdateSQL

Delphi

procedure SetParams(UpdateKind: TUpdateKind);

C++

void __fastcall SetParams(Data::Db::TUpdateKind UpdateKind);

Properties

Type	Visibility	Source	Unit	Parent
procedure function	public	IBX.IBUpdateSQL.pas IBX.IBUpdateSQL.hpp	IBX.IBUpdateSQL	TIBUpdateSQL

Description

Binds parameters in an SQL statement prior to statement execution.

Call SetParams to bind parameters in an SQL statement associated with the update object prior to executing the statement. UpdateKind indicates the type of statement for which to bind parameters, and can be one of the following values:

Value	Meaning
ukModify	Bind parameters for the SQL statement used to update records
ukInsert	Bind parameters for the SQL statement used to insert new records
ukDelete	Bind parameters for the SQL statement used to delete records

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 dataset.

Note: Parameter names can be prefaced by the 'OLD_' indicator. If so, the old value of the field is used to perform the update instead of any updates in the cache.