GetNextExtended
Applies to
VAccess
Description
Attempts to retrieve the next records in the current index path as an extended fetch record set, and returns, as an Integer value, the PSQL status code.
Syntax
object.GetNextExtended
The syntax for this method has the following parts:
 
Remarks
This method has no effect if the ExtendedOps property of the control is False or AutoMode is set to True.
This method performs a PSQL Get Next 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. The Init method automatically sets the IncludeCurrent property True. The GetNextExtended method sets the IncludeCurrent property False after the method is invoked.
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. A non-zero status code does not necessarily indicate that no records were returned—check the value of the Rows property to determine the number of rows returned.
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 GetFirst or GetGreaterOrEqual.
The ExtendedOps property must be set to True to enable the extended operations capabilities of the VAccess control.
Example
'read and print the records in the orders file
Orders.GetFirst
Orders.Init
Do
Orders.GetNextExtended
For r = 1 to Orders.Rows
For c = 1 to Orders.Columns
Debug.Print Orders.RowColumnValue(r,c)
Next c
Debug.Print 'new line
Next r
Loop While Orders.Status = 0