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.
Warning: SQL methods, $filter, $refilter and $unfilter are not available in client methods.
| $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(wRow[,bByName=kFalse]) assign column values from the row wRow by column number or name (pass bByName as kTrue to assign by name rather than number) |
| $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. |
| $copydefinition | $copydefinition(listOrRow[,params...]) copies the definition of listOrRow to the calling list or row variable. If listOrRow contains a table instance the method passes parameters 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,params...]) clears and defines the list or row using the class,and creates a table instance. Passes parameters to $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 |