TDAMSSQLBaseConnection

 

Creates a new instance.

constructor Create(aDriver: TDAEDriver; aName: string)

Parameters:

• aDriver: owner driver.
• aName: name of connection.

---

Parses connection string via calling of DoApplyConnectionString

procedure ApplyConnectionString(const aConnectionString: string; aConnectionObject: TCustomConnection)

Parameters:

• aConnectionString: Connection string
• aConnectionObject: Connection

---

Assigns OnBeforeExecute, OnAfterExecute and OnExecuteError events to correspondent events of aCommand

procedure AssignCommandEventHandlers(const aCommand: IDASQLCommand)

Parameters:

• aCommand: Command

---

Assigns OnBeforeOpen, OnAfterOpen and OnExecuteOpen events to correspondent events of aDataset

procedure AssignDatasetEventHandlers(const aDataset: IDADataset)

Parameters:

• aDataset: Dataset

---

Starts transaction via calling of DoBeginTransaction.

function BeginTransaction: Integer

---

Closes a physical connection to the database back-end,

procedure Close

---

Commits transaction via calling of DoCommitTransaction.

procedure CommitTransaction

---

Indicates whether the connection object currently has an active link to the database (true) or not (false). Usually, a Data Abstract connection connects to the database when it is created, and is not closed until discarded and eventually removed from the connection pool.

property Connected: Boolean read write

---

Holds a reference to the TDAConnection

property ConnectionDefinition: TDAConnection read

---

Holds a reference to the IDAConnectionManager.

property ConnectionManager: IDAConnectionManager read

---

Holds the connection name.

property ConnectionName: string read

---

Provides access to the internal connection component and facilitates access to its properties in form of a collection of properties.

property ConnectionObject: TCustomConnection read write

---

Provides access to the IDAConnectionPool.

property ConnectionPool: IDAConnectionPool read write

---

Returns value of given property

property ConnectionProperties[aPropertyName: string]: Variant read write

---

Sets the database connection string that was used to open this connection. The exact content of this string depends on the driver and database you are using, but it will usually contain information such as the database name, user id and password, as well as additional connection parameters. Please refer to the reference for the specific driver for more details.

property ConnectionString: string read write

---

Holds the connection type.

property ConnectionType: string read

---

Creates standard TCustomConnection

function CreateCustomConnection: TCustomConnection

---

Creates a macro processor.

function CreateMacroProcessor: TDASQLMacroProcessor

---

Parses connection string

procedure DoApplyConnectionString(aConnStrParser: TDAConnectionStringParser; aConnectionObject: TCustomConnection)

Parameters:

• aConnStrParser: Parser
• aConnectionObject: Connection

---

Starts transaction.

function DoBeginTransaction: Integer

---

Commits transaction.

procedure DoCommitTransaction

---

Fills ForeignKeys with actual foreign keys.

procedure DoGetForeignKeys(out ForeignKeys: TDADriverForeignKeyCollection)

Parameters:

• ForeignKeys: collection that will be filled.

---

Returns the transaction state.

function DoGetInTransaction: Boolean

---

Returns last auto increment value.

function DoGetLastAutoInc(const GeneratorName: string): Integer

Parameters:

• GeneratorName: Specified generator name.

---

Returns last auto increment value.

function DoGetLastAutoIncValue(const GeneratorName: string): Variant

Parameters:

• GeneratorName: Specified generator name.

---

Returns the fields of a specified SQL.

procedure DoGetQueryFields(const aSQL: string; aParamsIfNeeded: TDAParamCollection; out Fields: TDAFieldCollection)

Parameters:

• aSQL: given SQL
• aParamsIfNeeded: optional parameters
• Fields: fields of SQL

---

Returns the list of stored procedures names.

procedure DoGetStoredProcedureNames(out List: IROStrings)

Parameters:

• List: Output list with names of stored procedures

---

Retrieves the stored procedure params.

procedure DoGetStoredProcedureParams(const aStoredProcedureName: string; out Params: TDAParamCollection)

Parameters:

• aStoredProcedureName: Stored procedure name
• Params: Output collection of parameters

---

Returns the fields of a specified table.

procedure DoGetTableFields(const aTableName: string; out Fields: TDAFieldCollection)

Parameters:

• aTableName: Specified data table name
• Fields: Output collection of data table fields

---

Returns the list of tables names.

procedure DoGetTableNames(out List: IROStrings)

Parameters:

• List: Output list of data table names

---

Returns the fields of a specified view.

procedure DoGetViewFields(const aViewName: string; out Fields: TDAFieldCollection)

Parameters:

• aViewName: Specified view name
• Fields: Output collection of data table fields

---

Returns the list of view names.

procedure DoGetViewNames(out List: IROStrings)

Parameters:

• List: Output list of views

---

Rollbacks the transaction.

procedure DoRollbackTransaction

---

Reference to the owner TDAEDriver.

property Driver: TDAEDriver read

---

Returns connection state.

function GetConnected: Boolean

---

Returns the list of available databases.

function GetDatabaseNames: IROStrings

---

Returns the actual TDAEDatasetClass descendant.

function GetDatasetClass: TDAEDatasetClass

---

Fills ForeignKeys with actual foreign keys via calling of DoGetForeignKeys.

procedure GetForeignKeys(out ForeignKeys: TDADriverForeignKeyCollection)

Parameters:

• ForeignKeys: collection that will be filled.

---

Returns the generators list in IROStrings format. You can use the strings property to expose the underlying TString instance wrapped by this interface.

function GetGeneratorNames: IROStrings

---

Returns the transaction state via calling of DoGetInTransaction.

function GetInTransaction: Boolean

---

Returns last auto increment value as integer value via calling of DoGetLastAutoInc

function GetLastAutoInc(const GeneratorName: string): Integer

Parameters:

• GeneratorName: Specified generator name.

---

Returns last auto increment value as variant value via calling of DoGetLastAutoIncValue

function GetLastAutoIncValue(const GeneratorName: string): Variant

Parameters:

• GeneratorName: Specified generator name.

---

Return the connection name.

function GetName: string

---

Returns the next AutoInc value of a specified generator as integer value.

function GetNextAutoinc(const GeneratorName: string): Integer

Parameters:

• GeneratorName: Specified generator name.

---

Returns the next value of a specified generator as integer value.

function GetNextAutoinc2(const GeneratorName: string): Variant

Parameters:

• GeneratorName: Specified generator name.

---

Returns the password.

function GetPassword: string

---

Creates an instance of the TDAQueryBuilder.

function GetQueryBuilder: TDAQueryBuilder

---

Returns the fields of a specified SQL via calling of DoGetQueryFields

procedure GetQueryFields(const aSQL: string; aParamsIfNeeded: TDAParamCollection; out Fields: TDAFieldCollection)

Parameters:

• aSQL: given SQL
• aParamsIfNeeded: optional parameters
• Fields: fields of SQL

---

Returns correspondent TDASQLQueryGenerator instance

function GetQueryGenerator: TDASQLQueryGenerator

---

Returns quote symbols as an array.

function GetQuoteChars: TDAQuoteCharArray

---

Returns the syntax of a stored procedure for usage in a select query.

function GetSPSelectSyntax(HasArguments: Boolean): string

Parameters:

• HasArguments: parameters are present or not

---

Returns the actual TDAEStoredProcedure descendant.

function GetStoredProcedureClass: TDAEStoredProcedureClass

---

Returns the list of stored procedures names via calling of DoGetStoredProcedureNames.

procedure GetStoredProcedureNames(out List: IROStrings)

Parameters:

• List: list of stored procedures names

---

Retrieves the stored procedure params.

procedure GetStoredProcedureParams(const aStoredProcedureName: string; out Params: TDAParamCollection)

Parameters:

• aStoredProcedureName: stored procedure's name
• Params: stored procedure params.

---

Returns the fields of a specified table via calling of DoGetTableFields.

procedure GetTableFields(const aTableName: string; out Fields: TDAFieldCollection)

Parameters:

• aTableName: Specified data table name
• Fields: Output collection of data table fields

---

Returns the list of tables names via calling of DoGetTableNames.

procedure GetTableNames(out List: IROStrings)

Parameters:

• List: list of tables names.

---

Returns the user ID.

function GetUserID: string

---

Returns the fields of a specified view via calling of DoGetViewFields.

procedure GetViewFields(const aViewName: string; out Fields: TDAFieldCollection)

Parameters:

• aViewName: view's name
• Fields: fields of a specified view.

---

Returns the list of view names via calling of DoGetViewNames.

procedure GetViewNames(out List: IROStrings)

Parameters:

• List: list of view names.

---

Creates an instance of the TDASQL92WhereBuilder.

function GetWhereBuilder: TDASQLWhereBuilder

---

Returns True if the iIdentifier is quoted.

function IdentifierIsQuoted(const iIdentifier: string): Boolean

Parameters:

• iIdentifier: identifier.

---

Returns True if the iIdentifier should be quoted.

function IdentifierNeedsQuoting(const iIdentifier: string): Boolean

Parameters:

• iIdentifier: identifier.

---

Returns the transaction state

property InTransaction: Boolean read

---

Returns True if connection is alive.

function isAlive: Boolean

---

Specifies if Azure server is used

property isAzure: Boolean read write

---

Returns the correspondent TDASQLMacroProcessor.

property MacroProcessor: TDASQLMacroProcessor read

---

False by default.

property MSSQLSchemaEnabled: Boolean read write

---

Returns a human-readable name for the connection.

property Name: string read

---

Creates an IDASQLCommand based on CommandType.

function NewCommand(const Text: string; CommandType: TDASQLStatementType; const aCommandName: string): IDASQLCommand

Parameters:

• Text: stored procedure's name or SQL statement (depends on command type)
• CommandType: command type
• aCommandName: command name

---

Returns a new IDADataset implementation that can be used to retrieve records from the database.

function NewDataset(const SQL: string; const aDatasetName: string): IDADataset

Parameters:

• SQL: SQL statement
• aDatasetName: Dataset's name

---

Fires right after a command was executed.

property OnAfterExecuteCommand: TDAAfterExecuteCommandEvent read write
delegate:  procedure OnAfterExecuteCommand(const Sender: IDASQLCommand; ActualSQL: string; ElapsedMilliseconds: Cardinal)

---

Fires after dataset was opened

property OnAfterOpenDataset: TDAAfterOpenDatasetEvent read write
delegate:  procedure OnAfterOpenDataset(const Sender: IDADataset; ActualSQL: string; ElapsedMilliseconds: Cardinal)

---

Fires just before a command will be executed.

property OnBeforeExecuteCommand: TDABeforeExecuteCommandEvent read write
delegate:  procedure OnBeforeExecuteCommand(const Sender: IDASQLCommand)

---

Fires before dataset was opened

property OnBeforeOpenDataset: TDABeforeOpenDatasetEvent read write
delegate:  procedure OnBeforeOpenDataset(const Sender: IDADataset)

---

Fires when exception is detected during command execution

property OnExecuteCommandError: TDAExecuteCommandErrorEvent read write
delegate:  procedure OnExecuteCommandError(const Sender: IDASQLCommand; ActualSQL: string; Error: Exception)

---

Fired if error was occured duting opening of dataset

property OnOpenDatasetError: TDAOpenDatasetErrorEvent read write
delegate:  procedure OnOpenDatasetError(const Sender: IDADataset; ActualSQL: string; Error: Exception)

---

Sets UserID and Password if they are present and opens a physical connection to the database back-end,

procedure Open(const aUserID: string; const aPassword: string)

Parameters:

• aUserID: username
• aPassword: password

---

Defines the Password that was or will be used to open this connection. This value is usually obtained from the connection string.

property Password: string read write

---

Quotes field name.

function QuoteFieldName(const aTableName: string; const aFieldName: string): string

Parameters:

• aTableName: table name.
• aFieldName: field name.

---

Quotes field name if is required.

function QuoteFieldNameIfNeeded(const aTableName: string; const aFieldName: string): string

Parameters:

• aTableName: table name.
• aFieldName: field name.

---

Quotes identifier.

function QuoteIdentifier(const iIdentifier: string): string

Parameters:

• iIdentifier: identifier.

---

Quotes identifier if is required.

function QuoteIdentifierIfNeeded(const iIdentifier: string): string

Parameters:

• iIdentifier: identifier.

---

Creates MacroProcessor from scratch

procedure RecreateMacroProcessor

---

Discards a transaction that was started with a prior call to BeginTransaction, via calling of DoRollbackTransaction. All changes made in the context of the transaction will be be discarded and not applied to the physical database. To persist the changes made, instead of discarding them, call CommitTransaction instead.

procedure RollbackTransaction

---

Opens or closes a physical connection to the database back-end,

procedure SetConnected(Value: Boolean)

Parameters:

• Value: state

---

Sets the password.

procedure SetPassword(const Value: string)

Parameters:

• Value: password

---

Sets the user ID.

procedure SetUserID(const Value: string)

Parameters:

• Value: user ID

---

Tests connections.

procedure Test

---

Specifies an usage of macro processor.

property UseMacroProcessor: Boolean read write

---

Holds the User ID that was or will be used to open this connection. This value is usually obtained from the connection string.

property UserID: string read write

 

Indicates whether the connection object currently has an active link to the database (true) or not (false). Usually, a Data Abstract connection connects to the database when it is created, and is not closed until discarded and eventually removed from the connection pool.

property Connected: Boolean read write

---

Holds a reference to the TDAConnection

property ConnectionDefinition: TDAConnection read

---

Holds a reference to the IDAConnectionManager.

property ConnectionManager: IDAConnectionManager read

---

Holds the connection name.

property ConnectionName: string read

---

Provides access to the internal connection component and facilitates access to its properties in form of a collection of properties.

property ConnectionObject: TCustomConnection read write

---

Provides access to the IDAConnectionPool.

property ConnectionPool: IDAConnectionPool read write

---

Returns value of given property

property ConnectionProperties[aPropertyName: string]: Variant read write

---

Sets the database connection string that was used to open this connection. The exact content of this string depends on the driver and database you are using, but it will usually contain information such as the database name, user id and password, as well as additional connection parameters. Please refer to the reference for the specific driver for more details.

property ConnectionString: string read write

---

Holds the connection type.

property ConnectionType: string read

---

Reference to the owner TDAEDriver.

property Driver: TDAEDriver read

---

Returns the transaction state

property InTransaction: Boolean read

---

Specifies if Azure server is used

property isAzure: Boolean read write

---

Returns the correspondent TDASQLMacroProcessor.

property MacroProcessor: TDASQLMacroProcessor read

---

False by default.

property MSSQLSchemaEnabled: Boolean read write

---

Returns a human-readable name for the connection.

property Name: string read

---

Defines the Password that was or will be used to open this connection. This value is usually obtained from the connection string.

property Password: string read write

---

Specifies an usage of macro processor.

property UseMacroProcessor: Boolean read write

---

Holds the User ID that was or will be used to open this connection. This value is usually obtained from the connection string.

property UserID: string read write

 

Creates a new instance.

constructor Create(aDriver: TDAEDriver; aName: string)

Parameters:

• aDriver: owner driver.
• aName: name of connection.

---

Parses connection string via calling of DoApplyConnectionString

procedure ApplyConnectionString(const aConnectionString: string; aConnectionObject: TCustomConnection)

Parameters:

• aConnectionString: Connection string
• aConnectionObject: Connection

---

Assigns OnBeforeExecute, OnAfterExecute and OnExecuteError events to correspondent events of aCommand

procedure AssignCommandEventHandlers(const aCommand: IDASQLCommand)

Parameters:

• aCommand: Command

---

Assigns OnBeforeOpen, OnAfterOpen and OnExecuteOpen events to correspondent events of aDataset

procedure AssignDatasetEventHandlers(const aDataset: IDADataset)

Parameters:

• aDataset: Dataset

---

Starts transaction via calling of DoBeginTransaction.

function BeginTransaction: Integer

---

Closes a physical connection to the database back-end,

procedure Close

---

Commits transaction via calling of DoCommitTransaction.

procedure CommitTransaction

---

Creates standard TCustomConnection

function CreateCustomConnection: TCustomConnection

---

Creates a macro processor.

function CreateMacroProcessor: TDASQLMacroProcessor

---

Parses connection string

procedure DoApplyConnectionString(aConnStrParser: TDAConnectionStringParser; aConnectionObject: TCustomConnection)

Parameters:

• aConnStrParser: Parser
• aConnectionObject: Connection

---

Starts transaction.

function DoBeginTransaction: Integer

---

Commits transaction.

procedure DoCommitTransaction

---

Fills ForeignKeys with actual foreign keys.

procedure DoGetForeignKeys(out ForeignKeys: TDADriverForeignKeyCollection)

Parameters:

• ForeignKeys: collection that will be filled.

---

Returns the transaction state.

function DoGetInTransaction: Boolean

---

Returns last auto increment value.

function DoGetLastAutoInc(const GeneratorName: string): Integer

Parameters:

• GeneratorName: Specified generator name.

---

Returns last auto increment value.

function DoGetLastAutoIncValue(const GeneratorName: string): Variant

Parameters:

• GeneratorName: Specified generator name.

---

Returns the fields of a specified SQL.

procedure DoGetQueryFields(const aSQL: string; aParamsIfNeeded: TDAParamCollection; out Fields: TDAFieldCollection)

Parameters:

• aSQL: given SQL
• aParamsIfNeeded: optional parameters
• Fields: fields of SQL

---

Returns the list of stored procedures names.

procedure DoGetStoredProcedureNames(out List: IROStrings)

Parameters:

• List: Output list with names of stored procedures

---

Retrieves the stored procedure params.

procedure DoGetStoredProcedureParams(const aStoredProcedureName: string; out Params: TDAParamCollection)

Parameters:

• aStoredProcedureName: Stored procedure name
• Params: Output collection of parameters

---

Returns the fields of a specified table.

procedure DoGetTableFields(const aTableName: string; out Fields: TDAFieldCollection)

Parameters:

• aTableName: Specified data table name
• Fields: Output collection of data table fields

---

Returns the list of tables names.

procedure DoGetTableNames(out List: IROStrings)

Parameters:

• List: Output list of data table names

---

Returns the fields of a specified view.

procedure DoGetViewFields(const aViewName: string; out Fields: TDAFieldCollection)

Parameters:

• aViewName: Specified view name
• Fields: Output collection of data table fields

---

Returns the list of view names.

procedure DoGetViewNames(out List: IROStrings)

Parameters:

• List: Output list of views

---

Rollbacks the transaction.

procedure DoRollbackTransaction

---

Returns connection state.

function GetConnected: Boolean

---

Returns the list of available databases.

function GetDatabaseNames: IROStrings

---

Returns the actual TDAEDatasetClass descendant.

function GetDatasetClass: TDAEDatasetClass

---

Fills ForeignKeys with actual foreign keys via calling of DoGetForeignKeys.

procedure GetForeignKeys(out ForeignKeys: TDADriverForeignKeyCollection)

Parameters:

• ForeignKeys: collection that will be filled.

---

Returns the generators list in IROStrings format. You can use the strings property to expose the underlying TString instance wrapped by this interface.

function GetGeneratorNames: IROStrings

---

Returns the transaction state via calling of DoGetInTransaction.

function GetInTransaction: Boolean

---

Returns last auto increment value as integer value via calling of DoGetLastAutoInc

function GetLastAutoInc(const GeneratorName: string): Integer

Parameters:

• GeneratorName: Specified generator name.

---

Returns last auto increment value as variant value via calling of DoGetLastAutoIncValue

function GetLastAutoIncValue(const GeneratorName: string): Variant

Parameters:

• GeneratorName: Specified generator name.

---

Return the connection name.

function GetName: string

---

Returns the next AutoInc value of a specified generator as integer value.

function GetNextAutoinc(const GeneratorName: string): Integer

Parameters:

• GeneratorName: Specified generator name.

---

Returns the next value of a specified generator as integer value.

function GetNextAutoinc2(const GeneratorName: string): Variant

Parameters:

• GeneratorName: Specified generator name.

---

Returns the password.

function GetPassword: string

---

Creates an instance of the TDAQueryBuilder.

function GetQueryBuilder: TDAQueryBuilder

---

Returns the fields of a specified SQL via calling of DoGetQueryFields

procedure GetQueryFields(const aSQL: string; aParamsIfNeeded: TDAParamCollection; out Fields: TDAFieldCollection)

Parameters:

• aSQL: given SQL
• aParamsIfNeeded: optional parameters
• Fields: fields of SQL

---

Returns correspondent TDASQLQueryGenerator instance

function GetQueryGenerator: TDASQLQueryGenerator

---

Returns quote symbols as an array.

function GetQuoteChars: TDAQuoteCharArray

---

Returns the syntax of a stored procedure for usage in a select query.

function GetSPSelectSyntax(HasArguments: Boolean): string

Parameters:

• HasArguments: parameters are present or not

---

Returns the actual TDAEStoredProcedure descendant.

function GetStoredProcedureClass: TDAEStoredProcedureClass

---

Returns the list of stored procedures names via calling of DoGetStoredProcedureNames.

procedure GetStoredProcedureNames(out List: IROStrings)

Parameters:

• List: list of stored procedures names

---

Retrieves the stored procedure params.

procedure GetStoredProcedureParams(const aStoredProcedureName: string; out Params: TDAParamCollection)

Parameters:

• aStoredProcedureName: stored procedure's name
• Params: stored procedure params.

---

Returns the fields of a specified table via calling of DoGetTableFields.

procedure GetTableFields(const aTableName: string; out Fields: TDAFieldCollection)

Parameters:

• aTableName: Specified data table name
• Fields: Output collection of data table fields

---

Returns the list of tables names via calling of DoGetTableNames.

procedure GetTableNames(out List: IROStrings)

Parameters:

• List: list of tables names.

---

Returns the user ID.

function GetUserID: string

---

Returns the fields of a specified view via calling of DoGetViewFields.

procedure GetViewFields(const aViewName: string; out Fields: TDAFieldCollection)

Parameters:

• aViewName: view's name
• Fields: fields of a specified view.

---

Returns the list of view names via calling of DoGetViewNames.

procedure GetViewNames(out List: IROStrings)

Parameters:

• List: list of view names.

---

Creates an instance of the TDASQL92WhereBuilder.

function GetWhereBuilder: TDASQLWhereBuilder

---

Returns True if the iIdentifier is quoted.

function IdentifierIsQuoted(const iIdentifier: string): Boolean

Parameters:

• iIdentifier: identifier.

---

Returns True if the iIdentifier should be quoted.

function IdentifierNeedsQuoting(const iIdentifier: string): Boolean

Parameters:

• iIdentifier: identifier.

---

Returns True if connection is alive.

function isAlive: Boolean

---

Creates an IDASQLCommand based on CommandType.

function NewCommand(const Text: string; CommandType: TDASQLStatementType; const aCommandName: string): IDASQLCommand

Parameters:

• Text: stored procedure's name or SQL statement (depends on command type)
• CommandType: command type
• aCommandName: command name

---

Returns a new IDADataset implementation that can be used to retrieve records from the database.

function NewDataset(const SQL: string; const aDatasetName: string): IDADataset

Parameters:

• SQL: SQL statement
• aDatasetName: Dataset's name

---

Sets UserID and Password if they are present and opens a physical connection to the database back-end,

procedure Open(const aUserID: string; const aPassword: string)

Parameters:

• aUserID: username
• aPassword: password

---

Quotes field name.

function QuoteFieldName(const aTableName: string; const aFieldName: string): string

Parameters:

• aTableName: table name.
• aFieldName: field name.

---

Quotes field name if is required.

function QuoteFieldNameIfNeeded(const aTableName: string; const aFieldName: string): string

Parameters:

• aTableName: table name.
• aFieldName: field name.

---

Quotes identifier.

function QuoteIdentifier(const iIdentifier: string): string

Parameters:

• iIdentifier: identifier.

---

Quotes identifier if is required.

function QuoteIdentifierIfNeeded(const iIdentifier: string): string

Parameters:

• iIdentifier: identifier.

---

Creates MacroProcessor from scratch

procedure RecreateMacroProcessor

---

Discards a transaction that was started with a prior call to BeginTransaction, via calling of DoRollbackTransaction. All changes made in the context of the transaction will be be discarded and not applied to the physical database. To persist the changes made, instead of discarding them, call CommitTransaction instead.

procedure RollbackTransaction

---

Opens or closes a physical connection to the database back-end,

procedure SetConnected(Value: Boolean)

Parameters:

• Value: state

---

Sets the password.

procedure SetPassword(const Value: string)

Parameters:

• Value: password

---

Sets the user ID.

procedure SetUserID(const Value: string)

Parameters:

• Value: user ID

---

Tests connections.

procedure Test

 

Fires right after a command was executed.

property OnAfterExecuteCommand: TDAAfterExecuteCommandEvent read write
delegate:  procedure OnAfterExecuteCommand(const Sender: IDASQLCommand; ActualSQL: string; ElapsedMilliseconds: Cardinal)

---

Fires after dataset was opened

property OnAfterOpenDataset: TDAAfterOpenDatasetEvent read write
delegate:  procedure OnAfterOpenDataset(const Sender: IDADataset; ActualSQL: string; ElapsedMilliseconds: Cardinal)

---

Fires just before a command will be executed.

property OnBeforeExecuteCommand: TDABeforeExecuteCommandEvent read write
delegate:  procedure OnBeforeExecuteCommand(const Sender: IDASQLCommand)

---

Fires before dataset was opened

property OnBeforeOpenDataset: TDABeforeOpenDatasetEvent read write
delegate:  procedure OnBeforeOpenDataset(const Sender: IDADataset)

---

Fires when exception is detected during command execution

property OnExecuteCommandError: TDAExecuteCommandErrorEvent read write
delegate:  procedure OnExecuteCommandError(const Sender: IDASQLCommand; ActualSQL: string; Error: Exception)

---

Fired if error was occured duting opening of dataset

property OnOpenDatasetError: TDAOpenDatasetErrorEvent read write
delegate:  procedure OnOpenDatasetError(const Sender: IDADataset; ActualSQL: string; Error: Exception)