|
Introduction |
|
Using SQL File Import |
|
|
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.
|
|