Data functions

In your scripts, you can set and retrieve the value of any other columns of the same row using the data functions.  Setting and retrieving the values by index is faster as the scripting engine does not need to search for the source column.  Column indexes are zero based i.e. the first column has the index value 0.

function GetSourceColumnValue(ColumnName: string): Variant;

Returns the ColumnName value of the current row.  Returns varNull if ColumnName does not exist.

function GetSourceColumnValueByIndex(ColumnIndex: Integer): Variant;

Returns the ColumnIndex value of the current row.  Returns varNull if ColumnIndex is out of range.

function SetSourceColumnValue(ColumnName: string; Value: Variant): Boolean;

Sets the ColumnName value of the current row to Value.  Returns False if ColumnName does not exist.

function SetSourceColumnValueByIndex(ColumnIndex: Integer; Value: Variant): Boolean;

Sets the ColumnIndex value of the current row to Value.  Returns False if ColumnIndex is out of range.