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 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).
The limit applies to short string fields as well as multiline text fields. A short string field can be up to 254 characters, so you may want to set a limit for it.
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(); }