RAD Studio VCL Reference
ContentsIndex
PreviousUpNext
TIBUpdateSQL.Query Property

Returns the query object used to perform a specified kind of update.

Pascal
property Query [UpdateKind: TUpdateKind]: TIBQuery;
C++
__property TIBQuery Query[TUpdateKind UpdateKind];

Query returns the TIBQuery object used to perform a particular form of SQL update. UpdateKind specifies which query object to retrieve. UpdateKind can be one of the following: 

Value Meaning  

ukModify Return the query object used to execute UPDATE statements 

ukInsert Return the query object used to execute INSERT statements 

ukDelete Return the query object used to execute DELETE statements 

Each query object executes a particular kind of SQL statement. The contents of the SQL statements executed by these objects can be accessed directly using the ModifySQL, InsertSQL, and DeleteSQL properties. 

The main purpose of Query is to provide a way for an application to set the properties for an update query object or to call the query object's methods.

Note: If a particular kind of update statement is not provided, then its corresponding query object is nil (Delphi) or NULL (C++). For example, if an application does not provide an SQL statement for the DeleteSQL property, then Query[ukDelete] returns nil or NULL.
 

 

Copyright(C) 2009 Embarcadero Technologies, Inc. All Rights Reserved.
What do you think about this topic? Send feedback!