MyDAC

TMyEmbConnection Members

TMyEmbConnection class overview.

Properties

Name Description

BaseDir

Used to set the base path for MySQL Embedded server.

ClientVersion (inherited from TCustomMyConnection)

Contains the version of the MySQL Client library.

ConnectDialog (inherited from TCustomDAConnection)

Allows to link a TCustomConnectDialog component.

ConnectionTimeout (inherited from TCustomMyConnection)

Used to specify the amount of time to attempt to establish a connection.

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 (inherited from TCustomMyConnection)

Used to specify a database name that is a default source of data for SQL queries once a connection is established.

DataDir

Used to set the path to the data directory.

InTransaction (inherited from TCustomDAConnection)

Indicates whether the transaction is active.

IsolationLevel (inherited from TCustomMyConnection)

Used to specify extent to which all outside transactions interfere with subsequent transactions of current connection.

LoginPrompt (inherited from TCustomDAConnection)

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

Options (inherited from TCustomMyConnection)

Specifies the behaviour of the TMyConnectionOptions object.

Params

Used to specify the list of command line parameters for Embedded server.

Password (inherited from TCustomDAConnection)

Serves to supply a password for login.

Pooling (inherited from TCustomDAConnection)

Enables or disables using connection pool.

PoolingOptions (inherited from TCustomDAConnection)

Specifies the behaviour of connection pool.

Server (inherited from TCustomDAConnection)

Serves to supply the server name for login.

ServerVersion (inherited from TCustomMyConnection)

Holds the version of MySQL server.

ThreadId (inherited from TCustomMyConnection)

Used to return the thread ID of the current connection.

Username (inherited from TCustomDAConnection)

Used to supply a user name for login.

Methods

Name Description

ApplyUpdates (inherited from TCustomDAConnection)

Overloaded. Applies changes in datasets.

AssignConnect (inherited from TCustomMyConnection)

Shares database connection between the TCustomMyConnection components.

Commit (inherited from TCustomDAConnection)

Commits current transaction.

Connect (inherited from TCustomDAConnection)

Establishes a connection to the server.

CreateDataSet (inherited from TCustomMyConnection)

Returns a new instance of TCustomMyDataSet class and associates it with this connection object.

CreateSQL (inherited from TCustomDAConnection)

Creates a component for queries execution.

Disconnect (inherited from TCustomDAConnection)

Performs disconnect.

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 TCustomMyConnection)

Executes any SQL statement outside TMyQuery or TMyCommand components.

ExecSQLEx (inherited from TCustomDAConnection)

Executes any SQL statement outside the TQuery or TSQL components.

GetCharsetNames (inherited from TCustomMyConnection)

Populates a string list with the names of available charsets.

GetDatabaseNames (inherited from TCustomDAConnection)

Returns a database list from the server.

GetExecuteInfo (inherited from TCustomMyConnection)

Returns the result of the last query execution.

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.

GetTriggerNames (inherited from TCustomMyConnection)

Returns a list of triggers from the server.

MonitorMessage (inherited from TCustomDAConnection)

Sends a specified message through the TCustomDASQLMonitor component.

Ping (inherited from TCustomDAConnection)

Used to check state of connection to the server.

ReleaseSavepoint (inherited from TCustomMyConnection)

Releases the specified savepoint without affecting any work that has been performed after its creation.

RemoveFromPool (inherited from TCustomDAConnection)

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

Rollback (inherited from TCustomDAConnection)

Discards all current data changes and ends transaction.

RollbackToSavepoint (inherited from TCustomMyConnection)

Cancels all updates for the current transaction.

Savepoint (inherited from TCustomMyConnection)

Defines a point in the transaction to which you can roll back later.

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.

OnLog

Occurs when MySQL server writes down to General Query Log.

OnLogError

Occurs when MySQL server writes down to Error Log.
© 1997-2017 Devart. All Rights Reserved. Request Support DAC Forum Provide Feedback