RAD Studio VCL Reference
ContentsIndex
PreviousUpNext
TUpdateSQL.Apply Method (TDataset, TUpdateKind)

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

Pascal
procedure Apply(UpdateKind: TUpdateKind); override; overload;
procedure Apply(ADataset: TDataset; UpdateKind: TUpdateKind); overload; reintroduce;
C++
virtual __fastcall Apply(TUpdateKind UpdateKind);
__fastcall Apply(TDataset ADataset, TUpdateKind UpdateKind);

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:

Value 
Meaning 
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.
 

DeleteSQL 

ExecSQL 

InsertSQL 

ModifySQL 

SetParams 

Using Multiple Update Objects

Copyright(C) 2008 CodeGear(TM). All Rights Reserved.
What do you think about this topic? Send feedback!