List.$cols.COLUMN

List.$cols

Properties

Object specific
$colsublen The field length of a list or schema column of type character
$colsubtype A constant or string representing the subtype of the list or schema column
$coltype A constant representing the type of the list or schema column kBinary kBoolean kCharacter kDate kFieldreference kInteger kItemref kList kNumber kObject kObjectref kPicture kRow kSequence
Standard $dataname $ident $name

Methods

$average $average([bSelectedLinesOnly=kFalse]) Returns the average of the non-null list column values
$clear $clear() clears the data for a list or row, or a column in a list or row; executing list. $clear() for a smart list sets $smartlist to kFalse, meaning that it is no longer a smart list
$count $count([bSelectedLinesOnly=kFalse]) returns the count of non-null values in the list column
$maximum $maximum([bSelectedLinesOnly=kFalse]) Returns the maximum of the non-null list column values
$minimum $minimum([bSelectedLinesOnly=kFalse]) Returns the minimum of the non-null list column values
$removeduplicates $removeduplicates(bSortNow,bIgnoreCase) removes rows with duplicate values in the column
$total $total([bSelectedLinesOnly=kFalse]) Returns the total of the non-null list column values