TMySQLDatabase.Properties

Please see TMySQLDatabase properties short descriptions below:

Connected

Indicates whether or not a database connection is active.

ConnectionCharacterSet

Sets connection character set.

ConnectionCollation

Sets connection collation.

ConnectionTimeout

Specifies the time interval to re-attempt a connection.

ConnectOptions

Sets DB connection parameters.

DatabaseName

Specifies the name of the database to associate with this database component.

DataSetCount

Indicates the number of active datasets associated with the connection component.

DataSets

Provides an indexed array of all active datasets for a database component.

Exclusive

Deprecated property, use MultiThreaded instead

Handle

Specifies the database handle.

HandleShared

Specifies whether or not to share a database handle.

Host

Sets HOST on which server is running.

InTransaction

Indicates whether a database transaction is in progress or not.

KeepConnection

Specifies whether an application remains connected to a database even if no datasets are open.

LastInsertID

Get last inserted value of AUTO_INCREMENT column from MySQL server

LoginPrompt

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

MaxAllowedPacketSize

Sets 'max_allowed_packet' connection parameter value in megabytes.

MultiThreaded

Allows usage of MySQL connection from several threads.

Params

Contains database connection parameters for the MySQL server.

Port

Sets server's port.

ReadOnly

Specifies that the database connection provides read-only access.

ServerVersion

Specifies server version like ineger number.

TransIsolation

Specifies the transaction isolation level for transactions.

UserName

The user ID with which you log on to the database.

UserPassword

To provide a password for the connection.

Utf8Used

Read this property value to ensure that UTF8 character set is used in the connection to MySQL server. This property is read-only.