EPUB | CHM | PDF

TPSQLDatabase.Properties.DatabaseID

Top Previous Next

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

Syntax:

property DatabaseID: cardinal;

Description:

Use read-only DatabaseID property to get unique integer value which identifies database within cluster.

You can use DatabaseID property for low level calls to server.

Example:

This example shows SQL statement that returns last system inserted OID in the database:

PSQLQuery1.SQL.Text := Format('SELECT datlastsysoid FROM pg_database ' +
 'WHERE oid = ''%u''',
 [PSQLQuery1.Database.DatabaseID]);

Since OID type is unsigned integer be carefull when mixing integer types in your application!