IBX.IBQuery.TIBQuery

From RAD Studio API Documentation
Jump to: navigation, search

IBX.IBCustomDataSet.TIBCustomDataSetData.DB.TDataSetSystem.Classes.TComponentSystem.Classes.TPersistentSystem.TObjectTIBQuery

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.

See Also