IDAADOConnection

 

Starts transaction.

function BeginTransaction: Integer

---

Closes a physical connection to the database back-end,

procedure Close

---

ConnectionTimeout specifies the amount of time, in seconds, that can expire before an attempt to make a connection is considered unsuccessful.

property CommandTimeout: Integer read write

---

Commits transaction.

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. However, you can use the Open and Close methods to manually connect or disconnect from the database, if needed.

property Connected: Boolean read write

---

Provides access to the IDAConnectionPool.

property ConnectionPool: IDAConnectionPool 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

---

Returns connection state.

function GetConnected: Boolean

---

Fills ForeignKeys with actual foreign keys.

procedure GetForeignKeys(out ForeignKeys: TDADriverForeignKeyCollection)

Parameters:

• ForeignKeys: collection that will be filled.

---

Returns last autoinc value.

function GetLastAutoInc(const GeneratorName: string): Integer

Parameters:

• GeneratorName: Specified generator name.

---

Returns last autoinc value.

function GetLastAutoIncValue(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.

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

Parameters:

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

---

Returns quote symbols as an array.

function GetQuoteChars: TDAQuoteCharArray

---

Returns select syntax for stored procedure.

function GetSPSelectSyntax(HasArguments: Boolean): string

Parameters:

• HasArguments: parameters are present or not

---

Returns the list of stored procedures names.

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.

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.

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.

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.

procedure GetViewNames(out List: IROStrings)

Parameters:

• List: list of view names.

---

Creates an instance of the TDASQLWhereBuilder.

function GetWhereBuilder: TDASQLWhereBuilder

---

Checks if identifier need to be quoted

function IdentifierNeedsQuoting(const iIdentifier: string): Boolean

Parameters:

• iIdentifier: identifier.

---

Indicates whether the connection is currently inside a transaction (true) or not (false). When inside a transaction, all changes made to the database are not applied to the physical database right away, but will be held until the transaction is commited. Then and only then will all changes be made permanent. Exact transaction behavior (such as transaction isolation) might also depend on the used database back-end setup and the connection parameters.

property InTransaction: Boolean read

---

Returns True if connection is alive.

function isAlive: Boolean

---

Returns a human-readable name for the connection. For connections obtained through a TDAConnectionManager component, this will be the name that the connection was defined under in Schema Modeler.

property Name: string read

---

Returns a new IDASQLCommand implementation that can be used to executing custom command that was previously defined in schema.

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 if error was present during execution of command.

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)

---

Establishes a physical connection to the database back-end, using the specified ConnectionString.

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

---

Specifies the OLE DB provider used by the connection. This is usually derived from the AuxDriver property of the connection string.

property ProviderName: string read

---

Indicates the database type of the provider (such as Microsoft SQL Server, Oracle, or Access), if known for the current provider.

property ProviderType: TDAOleDBProviderType read

---

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.

---

Discards a transaction that was started with a prior call to BeginTransaction. 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

---

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

 

ConnectionTimeout specifies the amount of time, in seconds, that can expire before an attempt to make a connection is considered unsuccessful.

property CommandTimeout: Integer 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. However, you can use the Open and Close methods to manually connect or disconnect from the database, if needed.

property Connected: Boolean read write

---

Provides access to the IDAConnectionPool.

property ConnectionPool: IDAConnectionPool 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

---

Indicates whether the connection is currently inside a transaction (true) or not (false). When inside a transaction, all changes made to the database are not applied to the physical database right away, but will be held until the transaction is commited. Then and only then will all changes be made permanent. Exact transaction behavior (such as transaction isolation) might also depend on the used database back-end setup and the connection parameters.

property InTransaction: Boolean read

---

Returns a human-readable name for the connection. For connections obtained through a TDAConnectionManager component, this will be the name that the connection was defined under in Schema Modeler.

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 the OLE DB provider used by the connection. This is usually derived from the AuxDriver property of the connection string.

property ProviderName: string read

---

Indicates the database type of the provider (such as Microsoft SQL Server, Oracle, or Access), if known for the current provider.

property ProviderType: TDAOleDBProviderType read

---

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

 

Starts transaction.

function BeginTransaction: Integer

---

Closes a physical connection to the database back-end,

procedure Close

---

Commits transaction.

procedure CommitTransaction

---

Returns connection state.

function GetConnected: Boolean

---

Fills ForeignKeys with actual foreign keys.

procedure GetForeignKeys(out ForeignKeys: TDADriverForeignKeyCollection)

Parameters:

• ForeignKeys: collection that will be filled.

---

Returns last autoinc value.

function GetLastAutoInc(const GeneratorName: string): Integer

Parameters:

• GeneratorName: Specified generator name.

---

Returns last autoinc value.

function GetLastAutoIncValue(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.

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

Parameters:

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

---

Returns quote symbols as an array.

function GetQuoteChars: TDAQuoteCharArray

---

Returns select syntax for stored procedure.

function GetSPSelectSyntax(HasArguments: Boolean): string

Parameters:

• HasArguments: parameters are present or not

---

Returns the list of stored procedures names.

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.

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.

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.

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.

procedure GetViewNames(out List: IROStrings)

Parameters:

• List: list of view names.

---

Creates an instance of the TDASQLWhereBuilder.

function GetWhereBuilder: TDASQLWhereBuilder

---

Checks if identifier need to be quoted

function IdentifierNeedsQuoting(const iIdentifier: string): Boolean

Parameters:

• iIdentifier: identifier.

---

Returns True if connection is alive.

function isAlive: Boolean

---

Returns a new IDASQLCommand implementation that can be used to executing custom command that was previously defined in schema.

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

---

Establishes a physical connection to the database back-end, using the specified ConnectionString.

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.

---

Discards a transaction that was started with a prior call to BeginTransaction. 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

 

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 if error was present during execution of command.

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)