TPSQLDatabase.Methods

Please see TPSQLDatabase methods short descriptions below:

Close

Closes the connection.

CloseDataSets

Closes all datasets associated with the database component without disconnecting from the database server.

Commit

Permanently stores updates, insertions, and deletions of data associated with the current transaction, and ends the current transactions.

Create

Creates an instance of a TPSQLDatabase component.

Destroy

Destroys the instance of a database component.

Execute

Executes an SQL statement.

GetDatabases

Populates a stringlist with the names of persistent PostgreSQL databases.

GetBackendPID

Returns the process ID of the backend server handling this connection.

GetCharSets

Returns list of charsets available for client encoding.

GetStoredProcNames

Returns list of stored procedures available at the moment.

GetSchemaNames

Populates a string list with the names of schemas associated with a specified database component.

GetUserNames

Populates a string list with the names of users associated with a specified database component.

Open

Opens the connection.

Reset

Resets the communication channel to the server.

Rollback

Cancels all updates, insertions, and deletions for the current transaction and ends the transaction.

SelectStringXXX

Methods of this group execute SQL Query and return result as single value casted to the string type.

StartTransaction

Begins a new transaction against the database server.