The FetchRow method sets the current row in the cache to the row specified in the rowindex parameter. The data stream must have been opened in QY_CACHE mode.

This method has the following syntax:

After the FetchRow method is executed, the NextRow method retrieves the row at rowindex + 1 (if these are valid row numbers), and the PrevRow method positions the data stream at rowindex - 1. FetchRow(rowindex = 0) can be used to rewind the data stream to a position immediately before the first row (as if the data stream had just been opened).

If the FetchRow method is successful, it returns ER_OK. If it is not successful, it returns an error status. Descriptions of system constant values and their numeric equivalents are listed in Error Codes (see Error Codes).