RIV::FetchRow

The RIV::FetchRow method is used to fetch the next row from a results set retrieved by RIV::GetResultSet() and returns undef if there are no more rows to return.

Synopsis

RIV::FetchRow([$rsKey])

Parameters

$rsKey
The results set key that was returned by the RIV::GetResultSet() method.

Description

The RIV::FetchRow method is used to fetch the next row from a results set retrieved by RIV::GetResultSet() and returns undef if there are no more rows to return. Care must be taken to iterate over all rows in the results set (even if the data is not required) otherwise the memory that is allocated to hold remainder of the results set is not freed.

Example Usage

my $isSelect = 1;
$oql->Send($request, $isSelect);
my $rsKey = $app->RIV::GetResultSet();

if ($rsKey)
{
  while (my $dat = $app->RIV::FetchRow($rsKey))
  {
    # process data
  }
}

Returns

Upon completion, the RIV::FetchRow method returns a Perl hash that represents the next row of the results set, or undef if there is no more data.

See Also