EPUB | CHM | PDF

TPSQLDatabase.Properties

Top Previous Next

Please see TPSQLDatabase properties short descriptions below:

CharSet

Indicates client encoding used for connection.

Connected

Indicates whether or not a database connection is active.

ConnectionTimeout

Specifies amount of time to attempt a connection.

CommandTimeout

Specifies amount of time to attempt a statement execution.

Comment

Holds description assigned to database.

DatabaseID

Specifies the ID (oid) of the database associated with this database component.

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.

DesignOptions

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

ErrorVerbosity

Determines the verbosity of messages returned.

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

Indicates whether a client uses SSL connection.

IsTemplate

Indicates whether a database can serve as template.

IsUnicodeUsed

Indicates whether a client encoding is set to 'UTF8'.

KeepConnection

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

LoginPrompt

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

Owner

Contains database owner name.

Params

Contains database connection parameters for the PostgreSQL server.

Port

Sets server's port.

ReadOnly

Specifies that the database connection provides read-only access.

ServerVersion

Contains server version string.

ServerVersionAsInt

Returns an integer representing the backend version.

SSLCert

File containing the X.509 certificate.

SSLCRL

File containing the SSL certificate revocation list (CRL).

SSLKey

File containing the Key for the X.509 certificate.

SSLMode

SSL mode connection option.

SSLRootCert

File containing the root SSL certificate.

Tablespace

Specifies the database tablespace within the cluster.

TransIsolation

Specifies the transaction isolation level for transactions.

TransactionStatus

Specifies the current transaction status.

UserName

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

UserPassword

To provide a Password for the connection.