List row

Row variables behave in exactly the same way as list variables, except that some list methods do not apply to row variables since they have only one line.

Properties

Object specific
$colcount Returns the number of columns in the list
Standard $desc $ident $name $sublen $subtype $type

Methods

Warning: SQL methods, $filter, $refilter, $unfilter, $search, $sort and $totc are not available in client methods.

Method Description
$addcols $addcols(cName,type,subtype,maxlen,...) adds 1 or more columns to a list or row. Specify each column with 4 parameters: cName, data type constant e.g. kCharacter (not kObject), subtype and maxlen
$assigncols $assigncols(value1,value2,...) assign the column values
$assignrow $assignrow(row,byname) assign column values from the row by column number or name
$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
$copydefinition $copydefinition(listOrRow[,param...]) copies the definition of listOrRow to the calling list or row variable. If listOrRow contains a table instance the method passes param... to $construct of the new instance
$define $define([var1,var2,...]) defines a list or row; the columns have the names and types of the parameters. Each parameter can also be a file class name (a string) from which all columns are used; append /S to the file class name to skip empty columns
$definefromsqlclass $definefromsqlclass(sqlclass[,wRow,param,...]) clears and defines the list or row using the class, and creates a table instance passing param... to table $construct. wRow is a row of schema column names to use (no names means use all)
$loadcols $loadcols(var1,var2,...) download the column values into the variables
$redefine $redefine([var1,var2,...]) redefines a list or row variable with the names of the parameters. Each parameter can also be a file class name(a string) from which all columns are used; append /S to the file class name to skip empty columns
$reportpos $reportpos(rInstance[,iMode,iSectID,iVPage,iHPage,nTop,nLeft,nHeight,nWidth]) stores a report position into a row variable
$totc $totc(expression[,bSelectedOnly=kFalse]) returns the total of the expression evaluated for either all lines in the list, or if bSelectedOnly is kTrue, all selected lines in the list

Children

$cols