SDAC

TCustomDAConnection Members

TCustomDAConnection class overview.

Properties

Name Description

ConnectDialog

Allows to link a TCustomConnectDialog component.

ConnectString

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

ConvertEOL

Allows customizing line breaks in string fields and parameters.

InTransaction

Indicates whether the transaction is active.

LoginPrompt

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

Options

Specifies the connection behavior.

Password

Serves to supply a password for login.

Pooling

Enables or disables using connection pool.

PoolingOptions

Specifies the behaviour of connection pool.

Server

Serves to supply the server name for login.

Username

Used to supply a user name for login.

Methods

Name Description

ApplyUpdates

Overloaded. Applies changes in datasets.

Commit

Commits current transaction.

Connect

Establishes a connection to the server.

CreateSQL

Creates a component for queries execution.

Disconnect

Performs disconnect.

ExecProc

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

ExecProcEx

Allows to execute a stored procedure or function.

ExecSQL

Executes a SQL statement with parameters.

ExecSQLEx

Executes any SQL statement outside the TQuery or TSQL components.

GetDatabaseNames

Returns a database list from the server.

GetKeyFieldNames

Provides a list of available key field names.

GetStoredProcNames

Returns a list of stored procedures from the server.

GetTableNames

Provides a list of available tables names.

MonitorMessage

Sends a specified message through the TCustomDASQLMonitor component.

Ping

Used to check state of connection to the server.

RemoveFromPool

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

Rollback

Discards all current data changes and ends transaction.

StartTransaction

Begins a new user transaction.

Events

Name Description

OnConnectionLost

This event occurs when connection was lost.

OnError

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