IBX.IBUpdateSQL.TIBUpdateSQL.Query

From RAD Studio API Documentation
Jump to: navigation, search

Delphi

property Query[UpdateKind: TUpdateKind]: TIBQuery read GetQuery;

C++

__property Ibx::Ibquery::TIBQuery* Query[Data::Db::TUpdateKind UpdateKind] = {read=GetQuery};

Properties

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

Description

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

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:

ValueMeaning
ukModifyReturn the query object used to execute UPDATE statements
ukInsertReturn the query object used to execute INSERT statements
ukDeleteReturn 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.