StepPreviousExtended
Applies to
VAccess
Description
Attempts to retrieve the previous records from the file in physical record storage order as an extended fetch record set, and returns, as an Integer value, the PSQL status code.
Syntax
object.StepPreviousExtended
The syntax for this method has the following parts:
 
Remarks
This method performs a PSQL Step Previous Extended operation, using the current record to establish initial positioning, and using the selection criteria contained in the SelectedRecords and SelectedFields properties.
If the IncludeCurrent property of the control is True, the extended fetch operation will begin with the current record. If this property is False, the extended fetch operation will begin with the next record in the record sequence.
If the operation is successful, the resulting record set values will be available through the Row and Column properties. The number of Rows and Columns returned by the operation are available in the Rows and Columns properties, and the PSQL status is returned by the method and is available in the Status property.
Before invoking this method, you must first configure the control for extended fetch operations by setting the desired record selection and field selection criteria in the SelectedRecords and SelectedFields properties, and then invoking the Init method to allocate the necessary request buffer structures. You can also first establish current record positioning in the file using a single record fetch method such as StepLast.
This method has no effect if the ExtendedOps property of the control is False or AutoMode is set to True.