Please see TPSQLQuery methods short descriptions below:
Derived from TDataSet
Returns a pointer to the buffer for the active record.
Adds a new, empty record to the end of the dataset.
Adds a new, populated record to the end of the dataset and posts it to the database.
Automatically posts or cancels data changes when an application changes which record in the dataset is the active record.
Clears the contents of all fields for the active record.
Closes a dataset.
Indicates whether data-aware controls do not update their display to reflect changes to the dataset.
Marks the internal cursor position as invalid.
Deletes the active record and positions the cursor on the next record.
Disables data display in data-aware controls associated with the dataset.
Enables editing of data in the dataset.
Re-enables data display in data-aware controls associated with the dataset.
Finds a field based on its name.
Searches for a specified field in the dataset.
Implements a virtual method for positioning the cursor on the first record in a filtered dataset.
Implements a virtual method for positioning the cursor on the last record in a filtered dataset.
Implements a virtual method for positioning the cursor on the next record in a filtered dataset.
Implements a virtual method for positioning the cursor on the previous record in a filtered dataset.
Positions the cursor on the first record in the dataset.
Frees the resources allocated for a specified bookmark.
Allocates a bookmark for the current cursor position in the dataset.
Fills a list with a dataset for every detail dataset that is not the value of a nested dataset field.
Retrieves a specified set of field objects into a list.
Retrieves a list of names for all fields in a dataset.
Retrieves an OID for associated field type, as it appears in pg_catalog.pg_type table.
Implements a virtual method to position the cursor on the record pointed to by a specified bookmark.
Inserts a new, empty record in the dataset.
Inserts a new, populated record to the dataset and posts it to the database.
Indicates whether the dataset contains no records.
Indicates whether a dataset is linked to a specified data source.
Positions the cursor on the last record in the dataset.
Positions the cursor on a record relative to the active record in the dataset.
Positions the cursor on the next record in the dataset.
Opens the dataset.
Positions the cursor on the previous record in the dataset.
Refetches data from the database to update a dataset's view of data.
Refetches the active record and the records that precede and follow it.
Sets the values for all fields in a record.
Positions the cursor on the active record.
In TPSQLDataset
Tests the validity of a specified bookmark.
Cancels modifications to the current record if those changes are not yet posted.
Checks the result of a call to the PostgreSQL.
Closes a database connection associated with the database.
Indicates the relationship between two bookmarks.
Retrieves all records from the current cursor position to the end of the file and stores them locally.
Posts all changes that have been written to the record buffer.
Reads BLOB data into a buffer.
Retrieves the current record into a buffer.
Retrieves an OID for associated field type, as it appears in pg_catalog.pg_type table.
Retrieves the current value of a field into a buffer.
Retrieves information about the current index into the index data fields of the dataset.
Searches the dataset for a specified record and makes that record the current record.
Retrieves field values from a record that matches specified search values.
Opens the database that contains the dataset.
Writes a modified record to the database.
Sorts opened dataset on the client side.
Converts a data string between the ANSI character set used by Delphi (and Windows), and the local code page (OEM character set).
In TPSQLQuery
Creates an instance of a query component.
Destroys the instance of a query.
Executes the SQL statement for the query.
Fills lists with the master and detail fields of the link.
Accesses parameter information based on a specified parameter name.
Sends a query for optimization prior to execution.
Frees the resources allocated for a previously prepared query.