Retrieving Sets of Records (Extended Operations)

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

Properties and Methods

Table 5-1 Properties and Methods for Extended Operations
Property or Method	Description
AutoMode	Enables or disables automatic caching of extended fetch data sets.
CacheRejectMax	Determines the maximum number of records which may be skipped in processing a single extended fetch operation using SelectedRecords criteria.
CacheRows	Determines the maximum number of rows to be returned by a single extended fetch operation.
CancelDialog	Enables or disables a dialog box allowing the user to cancel a sequence of single extended fetch operations.
Column	Determines the current column for an extended fetch result set.
ColumnName	Specifies the name of the current column in an extended fetch result set. Default is the name of the field assigned to the column.
Columns	Returns the total number of columns in an extended fetch result set.
ExtendedOps	Enables or disables extended fetch properties and methods for a data source.
FocusSelText	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.
IncludeCurrent	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.
Init	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.
MaxBufferSize	Specifies the size of the data buffer to use for extended fetch operations.
Row	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.
RowColumnValue	Returns a field value from a specified Row and Column in a extended fetch result set.
RowPosition	Returns the physical position of the record in the current row of an extended fetch result set.
Rows	Returns the number of valid rows of data in an extended fetch result set.
SelectedFields	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.

Events

Table 5-2 Events for Extended Operations
Event	Description
Logon	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.