Retrieving Sets of Records

Retrieving Sets of Records

This section lists the properties, methods, and events which you can use to retrieve sets of records.

Properties and Methods

Table 22

Properties and Methods for Extended Operations

Property or Method

Enables or disables automatic caching of extended fetch data sets.

Determines the maximum number of records which may be skipped in processing a single extended fetch operation using SelectedRecords criteria.

Determines the maximum number of rows to be returned by a single extended fetch operation.

Enables or disables a dialog box allowing the user to cancel a sequence of single extended fetch operations.

Determines the current column for an extended fetch result set.

Specifies the name of the current column in an extended fetch result set. Default is the name of the field assigned to the column.

Returns the total number of columns in an extended fetch result set.

Enables or disables extended fetch properties and methods for a data source.

Selects the text in the VATextBox when the text box receives focus.

GetNextExtended

Performs an extended fetch beginning at the current cursor position and proceeding forward along the current index path.

GetPreviousExtended

Performs an extended fetch beginning at the current cursor position and proceeding backwards along the current index path.

Determines whether the record set results of the next extended fetch operation performed will include the current record or will begin with the subsequent record.

Allocates extended fetch parameters prior to invoking an extended fetch method after changing the SelectedFields or SelectedRecords criteria or establishing new current positioning in the file.

Specifies the size of the data buffer to use for extended fetch operations.

Sets or returns the current row in an extended fetch result set. Used to access the result set from an extended fetch method or to navigate rows which meet the search criteria.

Returns a field value from a specified Row and Column in a extended fetch result set.

Returns the physical position of the record in the current row of an extended fetch result set.

Returns the number of valid rows of data in an extended fetch result set.

Specifies which fields to use as columns in an extended fetch result set. Default is an empty list, indicating that all fields should be included.

SelectedRecords

Specifies record selection criteria for the records to be returned in an extended fetch result set. The default is an empty list, indicating that all records should be included.

ShowSelectedFieldsDlg

Displays the property setting dialog box for the Selected Fields property.

ShowSelectedRecordsDlg

Displays the property setting dialog box for the Selected Records property.

StepNextExtended

Performs an extended fetch beginning at the current position and proceeding forward in physical record order.

StepPreviousExtended

Performs an extended fetch beginning at the current cursor position and proceeding backwards in physical record order.

Table 23

Events for Extended Operations

Fires when an extended fetch operation is completed. Returns the number of rows and number of columns of data contained in the returned data buffer.