Gets or sets the current limit on data to be fetched for a multiline, text field.
This is useful if your results include one or more fields containing a long, multiline text entry, and there is a chance that fetching the data could overrun your buffer space. It is also useful if you just want to browse results and want better performance.
By default, there is no limit on the length of data fetched from a multiline, text field.
You can reset the default by setting the length parameter to zero (0).
VBScript
resultset.MaxMultiLineTextLength resultset.MaxMultiLineTextLength max_length
Perl
$resultset->GetMaxMultiLineTextLength(); $resultset->SetMaxMultiLineTextLength($max_length);
Perl
$queryDefObj = $SessionObj->BuildQuery("Defect");
$queryDefObj->BuildField("description");
$queryDefObj->BuildField("id");
$resultSetObj = $SessionObj->BuildResultSet($queryDefObj);
$resultSetObj->SetMaxMultiLineTextLength(5);
# not setting the above max multiline text length
# or setting it to 0 will fetch the entire data of
# the long varchar column
$resultSetObj->Execute();
$status = $resultSetObj->MoveNext();
$i=0;
while ($status == 1) {
$xnote = $resultSetObj->GetColumnValue(1);
print $i++,". desc=",$xnote,"\n";
$entyObj = $SessionObj->GetEntity( "defect",
$resultSetObj->GetColumnValue(2));
$SessionObj->EditEntity($entyObj,"modify");
$entyObj->SetFieldValue("headline","testXXX".($i));
$retval = $entyObj->Validate();
$entyObj->Commit();
$status = $resultSetObj->MoveNext();
}