Language Reference Guide : 4. System Classes : DataStream Class : FetchRow Method
 
Share this page                  
FetchRow Method
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:
integer = DataStream.FetchRow(rowindex = integer)
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.