IBDAC

TIBCConnection Members

TIBCConnection class overview.

Properties

Name Description

AutoCommit

Used to permit or prevent permanent updates, insertions, and deletions of data associated with the current transaction against the database server.

ClientLibrary

Used to set or get the client library location.

ConnectDialog (inherited from TCustomDAConnection)

Allows to link a TCustomConnectDialog component.

Connected

Used to establish a database connection.

ConnectPrompt

Used to provide login support.

ConnectString (inherited from TCustomDAConnection)

Used to specify the connection information, such as: UserName, Password, Server, etc.

ConvertEOL (inherited from TCustomDAConnection)

Allows customizing line breaks in string fields and parameters.

Database

Used to set the name of the database to associate with TIBCConnection component.

DatabaseInfo

Used to get information about the connected database.

DBSQLDialect

Shows the database SQL dialect.

Debug

Used to display SQL statements being executed with their parameter values and data types.

DefaultTransaction

Used to access default database connection transaction.

Handle

Used to make calls directly to the InterBase API.

InTransaction (inherited from TCustomDAConnection)

Indicates whether the transaction is active.

LastError

Used to get the error code which resulted from the previous call to the InterBase server.

LoginPrompt (inherited from TCustomDAConnection)

Specifies whether a login dialog appears immediately before opening a new connection.

Options

Used to specify the behaviour of the TIBCConnection object.

Params

Used to specify the connection parameters.

Password

Used to specify the password for a connection.

Pooling (inherited from TCustomDAConnection)

Enables or disables using connection pool.

PoolingOptions (inherited from TCustomDAConnection)

Specifies the behaviour of connection pool.

Port

Used to specify the port number for connections to the server.

Server

Used to supply the server name to handle server's request for a login.

SQL

Used to execute any SQL statement.

SQLDialect

Used to set or return SQL Dialect used by InterBase client.

SSLOptions

Used to set up the SSL options.

TransactionCount

Used to return the number of transactions currently associated with this TIBCConnection component.

Transactions

Used to specify a transaction for the given index.

Username

Used to provide a user name.

Methods

Name Description

AddTransaction

Associates a TIBCTransaction component with the database component.

ApplyUpdates (inherited from TCustomDAConnection)

Overloaded. Applies changes in datasets.

AssignConnect

Shares database connection between the TIBCConnection components.

Commit (inherited from TCustomDAConnection)

Commits current transaction.

CommitRetaining

Stores to the database server all changes of data associated with the default database transaction permanently and then retains the transaction context.

Connect (inherited from TCustomDAConnection)

Establishes a connection to the server.

CreateDatabase

Creates an InterBase database.

CreateSQL (inherited from TCustomDAConnection)

Creates a component for queries execution.

Disconnect (inherited from TCustomDAConnection)

Performs disconnect.

DropDatabase

Used to drop database and remove database file from server.

ExecProc (inherited from TCustomDAConnection)

Allows to execute stored procedure or function providing its name and parameters.

ExecProcEx (inherited from TCustomDAConnection)

Allows to execute a stored procedure or function.

ExecSQL (inherited from TCustomDAConnection)

Executes a SQL statement with parameters.

ExecSQLEx (inherited from TCustomDAConnection)

Executes any SQL statement outside the TQuery or TSQL components.

FindDefaultTransaction

Returns the default transaction for the database.

GetDatabaseNames (inherited from TCustomDAConnection)

Returns a database list from the server.

GetKeyFieldNames (inherited from TCustomDAConnection)

Provides a list of available key field names.

GetStoredProcNames (inherited from TCustomDAConnection)

Returns a list of stored procedures from the server.

GetTableNames (inherited from TCustomDAConnection)

Provides a list of available tables names.

MonitorMessage (inherited from TCustomDAConnection)

Sends a specified message through the TCustomDASQLMonitor component.

ParamByName

POrovides access to the OUT parameters and their values after processing SQL statement.

Ping (inherited from TCustomDAConnection)

Used to check state of connection to the server.

RemoveFromPool (inherited from TCustomDAConnection)

Marks the connection that should not be returned to the pool after disconnect.

RemoveTransaction

Disassociates a specified transaction from the database.

Rollback (inherited from TCustomDAConnection)

Discards all current data changes and ends transaction.

RollbackRetaining

Rolls back all changes of data associated with the default database transaction to the database server and then retains the transaction context.

StartTransaction (inherited from TCustomDAConnection)

Begins a new user transaction.

Events

Name Description

OnConnectionLost (inherited from TCustomDAConnection)

This event occurs when connection was lost.

OnError (inherited from TCustomDAConnection)

This event occurs when an error has arisen in the connection.
© 1997-2022 Devart. All Rights Reserved. Request Support DAC Forum Provide Feedback