List defined from SQL class.$cols
| 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 |
| $excludefrominsert | If true, the column is excluded from the list of columns inserted by $insert,and from $insertnames |
| $excludefromupdate | If true, the column is excluded from the list of columns updated by $update,and from $updatenames |
| $excludefromwhere | If true, the column is excluded from where clauses generated by the table instance |
| Standard | $dataname $ident $name |
| $average | $average([bSelectedLinesOnly=kFalse]) Returns the average of the non-null list column values |
| $clear | $clear() clears the data for character,number,integer,date or boolean variables, 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=kFalse,bIgnoreCase=kFalse]) Removes adjacent rows with duplicate values of the column.If bSortNow,list is initially sorted by the column.bIgnoreCase affects character values |
| $selectduplicates | $selectduplicates([bSortNow=kFalse,bIgnoreCase=kFalse]) After clearing selection for all rows,selects adjacent rows with duplicate values of column.If bSortNow,list is initially sorted by the column.bIgnoreCase affects character values |
| $total | $total([bSelectedLinesOnly=kFalse]) Returns the total of the non-null list column values |