IBX.IBQuery.TIBQuery
Delphi
TIBQuery = class(TIBCustomDataSet)
C++
class PASCALIMPLEMENTATION TIBQuery : public Ibx::Ibcustomdataset::TIBCustomDataSet
Properties
| Type | Visibility | Source | Unit | Parent |
|---|---|---|---|---|
| class | public | IBX.IBQuery.pas IBX.IBQuery.hpp |
IBX.IBQuery | IBX.IBQuery |
Description
TIBQuery executes an InterBase SQL statement.
Use TIBQuery to access one or more tables in a database using SQL statements. The TIBQuery component provides a read-only dataset and adapts well to the InterBase client/server environment. To update the result set that TIBQuery represents, use this component in conjunction with a TIBUpdateSQL component.
Query components are useful because they can:
- Access more than one table at a time (called a 'join' in SQL).
- Automatically access a subset of rows and columns in its underlying tables, rather than always returning all rows and columns.
Note: TIBQuery is of particular importance to the development of scalable database applications. If there is any chance that an application built to run against local databases will be scaled to a remote SQL database server in the future, use TIBQuery components from the start to ensure easier scaling later.