MaxResultSetRows

Description

Sets or returns the soft limit on the number of records returned in a result set.

The MaxResultSetRows value is the soft limit value that limits the number of rows in the ResultSet. Clients can override the value of the soft limit, as long as the soft limit value is less than the hard, or absolute, limit. When the value of MaxResultSetRows is 0, the hard limit is used.

Remarque : Cette méthode est disponible dans la version 7.1.

Syntaxe

VBScript

resultset.MaxResultSetRows 
resultset.MaxResultSetRows limit 

Perl

$resultset->GetMaxResultSetRows();
$resultset->SetMaxResultSetRows($limit); 
Identificateur
Description
resultset
A ResultSet object, representing the rows and columns of data resulting from a query.
limit
A Long specifying the limit of rows returned in a ResultSet.
Valeur de retour
Returns a Long containing the limit for the number of rows returned in a ResultSet.

Exemple

Perl

 # limit a ResultSet to 10000 rows
 my $CQWorkSpace = $CQSession->GetWorkSpace();
 my $qry = $CQWorkSpace->GetQueryDef("Public Queries/Some Big Query");
 my $ResultSet = $CQSession->BuildResultSet($qry);
 $ResultSet->SetMaxResultSetRows(10000);
 $ResultSet->Execute();

Commentaires