TSQLQuery

type TSQLQuery = class(TCustomSQLQuery)

public

  property SchemaType: TSchemaType;

Schema type.

  property StatementType: TStatementType;

SQL statement type.

published

  property MaxIndexesCount: Integer;

Maximum allowed number of indexes.

  property FieldDefs: TFieldDefs;

Definitions of available fields in the underlying database.

  property Active: Boolean;

Is the dataset open or closed.

  property AutoCalcFields: Boolean;

How often should the value of calculated fields be calculated.

  property Filter: string;

Filter to apply to the data in memory.

  property Filtered: Boolean;

Is the filter active or not.

  property AfterCancel: TDataSetNotifyEvent;

Event triggered after a Cancel operation.

  property AfterClose: TDataSetNotifyEvent;

Event triggered after the dataset is closed.

  property AfterDelete: TDataSetNotifyEvent;

Event triggered after a successful Delete operation.

  property AfterEdit: TDataSetNotifyEvent;

Event triggered after the dataset is put in edit mode.

  property AfterInsert: TDataSetNotifyEvent;

Event triggered after the dataset is put in insert mode.

  property AfterOpen: TDataSetNotifyEvent;

Event triggered after the dataset is opened.

  property AfterPost: TDataSetNotifyEvent;

Event called after changes have been posted to the underlying database.

  property AfterRefresh: TDataSetNotifyEvent;

Event triggered after the data has been refreshed.

  property AfterScroll: TDataSetNotifyEvent;

Event triggered after the cursor has changed position.

  property BeforeCancel: TDataSetNotifyEvent;

Event triggered before a Cancel operation.

  property BeforeClose: TDataSetNotifyEvent;

Event triggered before the dataset is closed.

  property BeforeDelete: TDataSetNotifyEvent;

Event triggered before a Delete operation.

  property BeforeEdit: TDataSetNotifyEvent;

Event triggered before the dataset is put in edit mode.

  property BeforeInsert: TDataSetNotifyEvent;

Event triggered before the dataset is put in insert mode.

  property BeforeOpen: TDataSetNotifyEvent;

Event triggered before the dataset is opened.

  property BeforePost: TDataSetNotifyEvent;

Event called before changes are posted to the underlying database.

  property BeforeRefresh: TDataSetNotifyEvent;

Event triggered before the data is refreshed.

  property BeforeScroll: TDataSetNotifyEvent;

Event triggered before the cursor changes position.

  property OnCalcFields: TDataSetNotifyEvent;

Event triggered when values for calculated fields must be computed.

  property OnDeleteError: TDataSetErrorEvent;

Event triggered when a delete operation fails.

  property OnEditError: TDataSetErrorEvent;

Event triggered when an edit operation fails.

  property OnFilterRecord: TFilterRecordEvent;

Event triggered to filter records.

  property OnNewRecord: TDataSetNotifyEvent;

Event triggered when a new record is created.

  property OnPostError: TDataSetErrorEvent;

Event triggered when a post operation fails.

  property Database: TDataBase;

The TSQLConnection instance on which to execute SQL Statements.

  property Transaction: TDBTransaction;

Transaction in which to execute SQL statements.

  property ReadOnly: Boolean;

  property SQL: TStringList;

The SQL statement to execute.

  property InsertSQL: TStringList;

Statement to be used when inserting a new row in the database.

  property UpdateSQL: TStringList;

Statement to be used when updating an existing row in the database.

  property DeleteSQL: TStringList;

Statement to be used when deleting a new row in the database.

  property RefreshSQL: TStringList;

Refresh query to re-fetch field values after a DB update.

  property IndexDefs: TIndexDefs;

Index definitions for the dataset.

  property Options: TSQLQueryOptions;

Options controlling the behaviour of the dataset.

  property Params: TParams;

Parameters detected in the SQL statement.

  property ParamCheck: Boolean;

Should the SQL statement be checked for parameters.

  property Macros: TParams;

Set of macros for this SQL statement.

  property MacroCheck: Boolean;

Check for macros in the SQL statement.

  property MacroChar: AnsiChar;

Macro delimiter character.

  property ParseSQL: Boolean;

Should the SQL statement be parsed or not.

  property UpdateMode: TUpdateMode;

How to create update SQL statements.

  property UsePrimaryKeyAsKey: Boolean;

Should primary key fields be marked pfInKey.

  property DataSource: TDataSource;

Source for parameter values for unbound parameters.

  property Sequence: TSQLSequence;

Sequence to use for auto-generating values using a sequence.

  property ServerFilter: string;

Append server-side filter to SQL statement.

  property ServerFiltered: Boolean;

Should server-side filter be applied.

  property ServerIndexDefs: TServerIndexDefs;

List of indexes on the primary table of the query.

end;

TSQLQuery

Class to handle SQL commands (with or without result set).

TCustomSQLQuery

Custom Class to handle SQL commands (with or without result set).

TCustomBufDataset

Dataset connected to a database.

TDBDataset

Dataset connected to a database.

TDataSet

Base class for records-based data-access.

TComponent

TPersistent,IInterfaceComponentReference

TObject,IFPObserved

TSQLTransaction

Transaction in which a TSQLQuery is handled.

TSQLConnection

An abstract class representing a connection to a SQL Database.

TCustomSQLQuery.ExecSQL

Execute a SQL statement that does not return a result set.

TSQLQuery.SQL

The SQL statement to execute.