TADConnection Members

The following tables list the members exposed by TADConnection.

Event	Description
AfterCommit	Fires after transaction is committed.
AfterRollback	Fires after transaction is rolled back.
AfterStartTransaction	Fires after transaction is started.
BeforeCommit	Fires before transaction will be committed.
BeforeRollback	Fires before transaction will be rolled back.
BeforeStartTransaction	Fires before transaction will be started.
OnError	Fires before AnyDAC will raise exception.
OnLogin	Fires when an application connects to a DBMS.
OnLosted	Fires after AnyDAC was not able to restore losted connection to DBMS.
OnRecover	Fires after AnyDAC discovered that connection to DBMS is losted.
OnRestored	Fires after AnyDAC successfully restored losted connection to DBMS.

TADConnection Class

Method	Description
AbortJob	Use the AbortJob method to abort all running dataset operations on this connection.
ApplyUpdates	Applies change logs of specified datasets to the DBMS.
CheckActive	Checks to see if the connection is active.
CheckConnectionDef	Checks that connection definition is filled correctly.
CheckInactive	Checks to see if the connection is inactive.
CheckOnline	Checks to see if the connection is in online mode.
Commit	Permanently stores modifications to the data made in the current transaction, and optionally ends the current transactions.
CommitRetaining	Permanently stores modifications to the data made in the current transaction, without ending the current transaction.
DecodeObjectName	Splits DB object name into parts.
EncodeObjectName	Assembles DB object name from it parts.
ExecSQL	Executes a SQL command without parameters.
ExecSQL	Executes SQL command with parameters.
ExecSQL	Executes a SQL command with parameters.
ExecSQLScalar	Executes a SQL command without parameters and fetches a single value.
ExecSQLScalar	Executes a SQL command with parameters and fetches a single value.
ExecSQLScalar	Executes a SQL command with parameters and fetches a single value.
GetCatalogNames	Populates a string list with the names of catalogs in a DB.
GetFieldNames	Populates a string list with the names of fields in a table.
GetGeneratorNames	Populates a string list with the names of generators / sequences / <how else> in a database.
GetInfoReport	Populates a string list with a detailed report about a connection state.
GetKeyFieldNames	Populates a string list with the names of key fields in a table.
GetLastAutoGenValue	Returns last auto generated value.
GetPackageNames	Populates a string list with the names of the packages in a DB.
GetSchemaNames	Populates a string list with the names of schemas in a DB.
GetStoredProcNames	Populates a string list with the names of stored procedures in a DB.
GetTableNames	Populates a string list with the names of tables in a DB.
Offline	Sets connection to offline mode.
Online	Sets connection to online mode.
Open	Open connection to the database, using specified connection string.
Open	Open connection to the database, using specified user name and password.
Open	Open connection to the database, using specified connection parameters, user name and password.
Ping	Pings the DBMS server.
RefreshMetadataCache	Invalidates meta data cache.
ReleaseClients	Performs resource releasing operation on all associated datasets and commands.
Rollback	Cancels all modifications to the data made in the current transaction and optionally ends transaction.
RollbackRetaining	Cancels all modifications to the data made in the current transaction, without ending the current transaction.
StartTransaction	Starts new transaction at database.

Property	Description
CliHandle	CLI handle for connection sharing.
CliObj	Returns a CLI connection wrapping object.
CommandCount	The number of assocciated TADCustomCommand objects.
Commands	Returns assocciated TADCustomCommand objects.
Connected	Gets / sets connection active status.
ConnectedStoredUsage	Controls how to use Connected property value saved to DFM.
ConnectionDefName	The name of connection definition to use.
ConnectionIntf	Returns the IADPhysConnection interface.
ConnectionMetaDataIntf	Returns an IADPhysConnectionMetadata interface.
ConnectionName	Specifies the name of the connection to associate with this connection object.
DataSets	Returns assocciated TADDataSet objects.
DriverName	Specifies the ID of the AnyDAC driver for the connection.
FetchOptions	The set of default options to control rows fetching.
FormatOptions	The set of default options to control data representation.
InTransaction	Indicates whether a connection transaction is in progress or not.
IsSQLBased	Property returns True, if a data source supports SQL language.
LastUsed	The date and time of last usage of the connection.
LoginDialog	Gets / sets the reference to login dialog interface.
LoginPrompt	Specifies whether a login dialog appears immediately before opening a new connection.
Messages	Returns a list of messages returned by DBMS after recent database operation.
Offlined	Gets / sets connection offline status.
OptionsIntf	The reference to IADStanOptions interface.
Params	Lists database connection parameters for the AnyDAC connection definition associated with the connection object.
RDBMSKind	Returns the brand of DBMS currently connected.
RefCount	Returns the number of references to this connection object.
ResourceOptions	The set of default options to control resources usage.
ResultConnectionDef	The actual connection definition used to establish connection to a DBMS.
SharedCliHandle	CLI handle shared with other connection.
Temporary	Shows whether a connection object is created on fly (temporary one) and managed automatically or a persistent one explicitly created, managed, and freed by the application.
Transaction	The reference to TADCustomTransaction object.
TxOptions	The set of options to control transactions.
UpdateOptions	The set of default options to control data updating.
UpdateTransaction	The reference to TADCustomTransaction object, which will be used to post changes to DB.

Events, TADConnection Class, Legend, Methods, Properties