Data.SqlExpr.TSQLTable
Delphi
TSQLTable = class(TCustomSQLDataSet)
C++
class PASCALIMPLEMENTATION TSQLTable : public TCustomSQLDataSet
Properties
| Type | Visibility | Source | Unit | Parent |
|---|---|---|---|---|
| class | public | Data.SqlExpr.pas Data.SqlExpr.hpp |
Data.SqlExpr | Data.SqlExpr |
Description
TSQLTable represents a database table that is accessed using dbExpress.
Use TSQLTable to represent a table on a database server that is accessed via TSQLConnection. TSQLTable generates a query to fetch all of the rows and columns in a table you specify. You can add a TSQLTable component to a form or data module at design time, or create one dynamically at runtime.
TSQLTable is a unidirectional dataset. Unlike other datasets, unidirectional datasets do not buffer multiple records in memory. Because of this, you can only navigate using the First and Next methods. There is no built-in editing support: you can only edit the data in an SQL table by explicitly creating an SQL UPDATE command or by connecting the table to a client dataset using a provider. Features that require buffering multiple records, such as filters or lookup fields, are not available.
Before you can use a TSQLTable component, it must be connected to the database server. Therefore, the first step to take when working with TSQLTable is to set the SQLConnection property. Once the dataset is connected to a server, use the TableName property to specify the table this component represents.