AccpacView.FetchEx

Retrieves the next record in the view according to the primary key field values of the current record, as well as the current filter and direction set by a previous call to Browse. This method is a network optimized version of Fetch. It allows field values to be set to the view before the operation, and also returns the field values of the requested fields, as well as the record number.

Function FetchEx(
PutFieldIDs As Variant,
PutFieldValues As Variant,
FieldIDs As Variant,
Values As Variant,
RecNum As Long) As Boolean

Parameters

PutFieldIDs

[in] an array of field IDs which represent the fields from which the values should first be modified before performing record fetching; the new values are specified in the PutFieldValues parameter

PutFieldValues

[in] an array of field values that should first be set to the view before performing record fetching; the values should appear in the array in the same order as their corresponding field IDs specified in the PutFieldIDs parameter

FieldIDs

[in] an array of field IDs representing the fields from which the values should be returned if a record is successfully retrieved

Values

[out] returns an array of field values for the requested fields; returns Null if no record is retrieved

RecNum

[out] returns the record number if a record is retrieved

Return Value

Returns whether a subsequent record exists in the view and is retrieved. The return value is the same as Fetch.

Remarks

This function first calls BlkPut (on PutFieldValues), and then Fetch, and then finally BlkGet to retrieve the field values. The record number is also retrieved.