Applies to: SQLBatX.dll

The following variables are available within ColdRED scripts and are replaced with their appropriate value:

Variables

<ConnectionKey>. can be omitted if you are referring the last used file or if you have set the file key previously with the USINGDB command.

Variable	Description
%[<ConnectionKey>.]OPTS.<OptionName>%	Value of the specified option.
%[<ConnectionKey>.]ROW.<ColumnName>%	Value of the specified column (of current row). The row collection is a free value collection and can differ from actual database row values. However you can read the values of the current row in the database into the row collection with the READROW command.
%[<ConnectionKey>.]DB.<ColumnName>%	Value of the specified column (of current record in query results).
%[<ConnectionKey>.]ROWS%	Affected rows of last executed SQL statement.

Further available all wmACScr1 variables.