Show: Delphi C++
Display Preferences

Data.SqlExpr.TSQLTable

From RAD Studio API Documentation
Jump to: navigation, search

Data.SqlExpr.TCustomSQLDataSetData.DB.TDataSetSystem.Classes.TComponentSystem.Classes.TPersistentSystem.TObjectTSQLTable

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.

See Also

Personal tools
In Other Languages
Previous Versions
Assistance