EPUB | CHM | PDF

TPSQLStoredProc.Methods

Top Previous Next

Please see TPSQLStoredProc methods short descriptions below:

Derived from TDataSet

ActiveBuffer

Returns a pointer to the buffer for the active record.

Append

Adds a new, empty record to the end of the dataset.

AppendRecord

Adds a new, populated record to the end of the dataset and posts it to the database.

CheckBrowseMode

Automatically posts or cancels data changes when an application changes which record in the dataset is the active record.

ClearFields

Clears the contents of all fields for the active record.

Close

Closes a dataset.

ControlsDisabled

Indicates whether data-aware controls do not update their display to reflect changes to the dataset.

CursorPosChanged

Marks the internal cursor position as invalid.

Delete

Deletes the active record and positions the cursor on the next record.

DisableControls

Disables data display in data-aware controls associated with the dataset.

Edit

Enables editing of data in the dataset.

EnableControls

Re-enables data display in data-aware controls associated with the dataset.

FieldByName

Finds a field based on its name.

FindField

Searches for a specified field in the dataset.

FindFirst

Implements a virtual method for positioning the cursor on the first record in a filtered dataset.

FindLast

Implements a virtual method for positioning the cursor on the last record in a filtered dataset.

FindNext

Implements a virtual method for positioning the cursor on the next record in a filtered dataset.

FindPrior

Implements a virtual method for positioning the cursor on the previous record in a filtered dataset.

First

Positions the cursor on the first record in the dataset.

FreeBookmark

Frees the resources allocated for a specified bookmark.

GetBookmark

Allocates a bookmark for the current cursor position in the dataset.

GetDetailDataSets

Fills a list with a dataset for every detail dataset that is not the value of a nested dataset field.

GetFieldList

Retrieves a specified set of field objects into a list.

GetFieldNames

Retrieves a list of names for all fields in a dataset.

GetFieldTypeOID

Retrieves an OID for associated field type, as it appears in pg_catalog.pg_type table.

GotoBookmark

Implements a virtual method to position the cursor on the record pointed to by a specified bookmark.

Insert

Inserts a new, empty record in the dataset.

InsertRecord

Inserts a new, populated record to the dataset and posts it to the database.

IsEmpty

Indicates whether the dataset contains no records.

IsLinkedTo

Indicates whether a dataset is linked to a specified data source.

Last

Positions the cursor on the last record in the dataset.

MoveBy

Positions the cursor on a record relative to the active record in the dataset.

Next

Positions the cursor on the next record in the dataset.

Open

Opens the dataset.

Prior

Positions the cursor on the previous record in the dataset.

Refresh

Refetches data from the database to update a dataset's view of data.

Resync

Refetches the active record and the records that precede and follow it.

SetFields

Sets the values for all fields in a record.

UpdateCursorPos

Positions the cursor on the active record.

In TPSQLDataset

BookmarkValid

Tests the validity of a specified bookmark.

Cancel

Cancels modifications to the current record if those changes are not yet posted.

CheckOpen

Checks the result of a call to the PostgreSQL.

CloseDatabase

Closes a database connection associated with the database.

CompareBookmarks

Indicates the relationship between two bookmarks.

FetchAll

Retrieves all records from the current cursor position to the end of the file and stores them locally.

FlushBuffers

Posts all changes that have been written to the record buffer.

GetBlobFieldData

Reads BLOB data into a buffer.

GetCurrentRecord

Retrieves the current record into a buffer.

GetFieldTypeOID

Retrieves an OID for associated field type, as it appears in pg_catalog.pg_type table.

GetFieldData

Retrieves the current value of a field into a buffer.

GetIndexInfo

Retrieves information about the current index into the index data fields of the dataset.

Locate

Searches the dataset for a specified record and makes that record the current record.

Lookup

Retrieves field values from a record that matches specified search values.

OpenDatabase

Opens the database that contains the dataset.

Post

Writes a modified record to the database.

SortBy

Sorts opened dataset on the client side.

Translate

Converts a data string between the ANSI character set used by Delphi (and Windows), and the local code page (OEM character set).

In TPSQLStoredProc

Create

Creates an instance of a stored procedure component.

DescriptionsAvailable

Determines if parameter information is available from the stored procedure on the server.

Destroy

Destroys the instance of a stored procedure.

ExecProc

Executes the stored procedure.

ParamByName

Accesses parameter information based on a specified parameter name.

RefreshParams

Rebuilds parameters list.

SetNeedRefreshParams

Sets internal flag to refetch parameters info from server by force on the next time RefreshParams call.