EPUB | CHM | PDF

TMySQLDatabase.Properties

Top Previous Next

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 awaiting for connection is established.

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.

DatasetOptions

Returns or sets common properties for all datasets (tables, queries, stored procedures) attached this TMySQLDatabase component.

DataSets

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

DesignOptions

Returns or sets database properties to organize the component behavior at design-time.

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.

IsSSLUsed

Read this property value to ensure that SSL encryption is used for connection to MySQL server.

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 integer number.

SSLCert

Containing the X.509 certificate.

SSLKey

Containing the Key for the X.509 certificate..

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.

WarningsCount

Returns number of warnings issued by server for latest query.