Skip to content

Properties of TSQLQuery

Properties

Member Visibility Description
Active read only published Is the dataset open or closed.
AfterCancel read only published Event triggered after a Cancel operation.
AfterClose read only published Event triggered after the dataset is closed.
AfterDelete read only published Event triggered after a successful Delete operation.
AfterEdit read only published Event triggered after the dataset is put in edit mode.
AfterInsert read only published Event triggered after the dataset is put in insert mode.
AfterOpen read only published Event triggered after the dataset is opened.
AfterPost read only published Event called after changes have been posted to the underlying database.
AfterRefresh read only published Event triggered after the data has been refreshed.
AfterScroll read only published Event triggered after the cursor has changed position.
AutoCalcFields read only published How often should the value of calculated fields be calculated.
BeforeCancel read only published Event triggered before a Cancel operation.
BeforeClose read only published Event triggered before the dataset is closed.
BeforeDelete read only published Event triggered before a Delete operation.
BeforeEdit read only published Event triggered before the dataset is put in edit mode.
BeforeInsert read only published Event triggered before the dataset is put in insert mode.
BeforeOpen read only published Event triggered before the dataset is opened.
BeforePost read only published Event called before changes are posted to the underlying database.
BeforeRefresh read only published Event triggered before the data is refreshed.
BeforeScroll read only published Event triggered before the cursor changes position.
Database read only published The TSQLConnection instance on which to execute SQL Statements.
DataSource read only published Source for parameter values for unbound parameters.
DeleteSQL read only published Statement to be used when deleting a new row in the database.
FieldDefs read only published Definitions of available fields in the underlying database.
Filter read only published Filter to apply to the data in memory.
Filtered read only published Is the filter active or not.
IndexDefs read only published Index definitions for the dataset.
InsertSQL read only published Statement to be used when inserting a new row in the database.
MacroChar read only published Macro delimiter character.
MacroCheck read only published Check for macros in the SQL statement.
Macros read only published Set of macros for this SQL statement.
MaxIndexesCount read only published Maximum allowed number of indexes.
ObjectView read only published
Options read only published Options controlling the behaviour of the dataset.
ParamCheck read only published Should the SQL statement be checked for parameters.
Params read only published Parameters detected in the SQL statement.
ParseSQL read only published Should the SQL statement be parsed or not.
ReadOnly read only published
RefreshSQL read only published Refresh query to re-fetch field values after a DB update.
SchemaType read only public Schema type.
Sequence read only published Sequence to use for auto-generating values using a sequence.
ServerFilter read only published Append server-side filter to SQL statement.
ServerFiltered read only published Should server-side filter be applied.
ServerIndexDefs read only published List of indexes on the primary table of the query.
SQL read only published The SQL statement to execute.
StatementType read only public SQL statement type.
Transaction read only published Transaction in which to execute SQL statements.
UpdateMode read only published How to create update SQL statements.
UpdateSQL read only published Statement to be used when updating an existing row in the database.
UsePrimaryKeyAsKey read only published Should primary key fields be marked pfInKey.