MaxMultiLineTextLength

Description

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.

Syntax

VBScript


resultset.MaxMultiLineTextLength 
resultset.MaxMultiLineTextLength max_length

Perl


$resultset->GetMaxMultiLineTextLength();

$resultset->SetMaxMultiLineTextLength($max_length);

Identifier: Description
resultset: A ResultSet object, representing the rows and columns of data resulting from a query.
max_length: A Long specifying the current maximum length in bytes of data fetched from a multiline text field.
Return value: Returns a Long containing the current maximum length in bytes of data fetched from a multiline text field.

Example

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();
}