System variables

System variables provide an easy way to reference specific information about the system, the data being worked on, and the active user's session, among other useful pieces of information.

System variable Description
i_ Row number in the current view
i_(B) Sticky row number in current view

B specifies a starting base number for the enumeration. The default is 1.

ii_(B) Enumeration of duplicate rows for each original row after performing a selection expansion (i.e., <sel expand="1">)

B specifies a starting base number for the enumeration. The default is 1.

n_ Number of rows in the current view
n_() Sticky number of rows in the current view
rn_ Row number in the original table
ri_ Row index relative to segment in the original table
zi_ Virtual column of integer zeros
zr_ Virtual column of real zeros
colord_ The current column order of the worksheet or table
dlpath_ Path of directory where data is stored
mach_ Internal designation of server on which data is being processed
name_ Path of this table, or N/A if it is a tabulation or other virtual table
orign_ Number of rows in original table
origname_ Path of the original table (pre-tabulation)
origtitle_ Title of the original table (pre-tabulation)
port_ Internal designation of port number for process handling data
rca_ Takes on the result of processing all columns up to the current one, during the evaluation of certain row functions. (Available as of version 15.21)
rcn_ Takes on the name of each column successively during the evaluation of a row function
rct_ Takes on one of the string values ('i', 'f', 'j', 'a', 'n') corresponding to the current column's basic data type: integer, float, bigint, string, or other, respectively, during the evaluation of a row function. (Available as of version 15.21)
rcv_ Takes on the value of each column successively during the evaluation of a row function
seg_ Segment in the original table
subtitle_ The subtitle of the worksheet currently being operated on
title_ Title of this table
username_ Username of user logged into current session
verdate_ The date the current version of MDB was released
version_ The MDB version number