GetNextExtended

Applies to:

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 Pervasive PSQL status code.

Syntax

object.GetNextExtended 
 



  

  
    
 

Part


    
 

Description



  
    
 

object


    
 

Required. The object placeholder represents an object expression that evaluates to an object in the Applies To list.

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 Pervasive 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 Pervasive 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.GetValue(r, c); 
      Next c 
      Debug.Print 'new line 
    Next r 
Loop While Orders.Status = 0