TIBQuery Class

TIBQuery executes an InterBase SQL statement.

Pascal

TIBQuery = class(TIBCustomDataSet);

C++

class TIBQuery : public TIBCustomDataSet;

File

IBQuery

Description

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 table(s), 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.