GetPreviousExtended
Applies to
VAccess
Description
Attempts to retrieve the previous records in the current index path as an extended fetch record set, and returns, as an Integer value, the PSQL status code.
Syntax
object.GetPreviousExtended
The syntax for this method has the following parts:
 
Remarks
This method performs a PSQL Get Previous Extended operation, using the current record and index selections in the control to establish 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 code 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 optimize the extended fetch operation by first establishing current record positioning in the index path using an indexed record fetch method such as GetLast or GetLessOrEqual.
This method has no effect if the ExtendedOps property of the control is False or if AutoMode is set to True.