TABLEROW Data Type

TABLEROW identifies a row in a table and is defined as follows.

type TABLEROW is INTEGER, STRING

The interpretation of a TABLEROW value depends on whether the type is an integer or a string.

  • An integer value specifies the 1-based index of the row.
  • A string value specifies the value of a column. The row is then obtained by searching for that value in the first column of the table. To search a column other than the first, the value should be preceded by the column name and an equal sign: "column-name = value". The value can contain wildcard characters. (You can also specify the index of the row as a string, in the form "#n" where n is the numerical index of the row.)