Object Inquiry Built-in Function

Return the value in a cell of a table.

[string|integer|float|boolean] cell COL_ID, ROWNUM of TABLE_NAME

#OR

[string|integer|float|boolean] cell column COL_ID

of row ROWNUM of TABLE_NAME

string | integer | float | boolean

Specify the type of data in the cell if you are using this cell reference as a source in a formula and the ESL compiler will not be able to determine the column being referenced (such as when you specify a variable name for COL_ID).

column

Include this keyword if you also include of row.

COL_ID

The identifier of a column.

ROWNUM

The number of a row in a table.

TABLE_NAME

The identifier of a table.

Description

Use this built-in function to refer to the contents of a specific cell in a table. To use this function, the parent of the table must be permanent and/or visible.

Example

 

cell column Sales of row 55 of SalesInfo_TBL

cell Sales, 55 of SalesInfo_TBL

integer cell CurCol, CurRow of SalesInfo_TBL

See Also

copy Action Statement

textual row of Object Inquiry Built-in Function

Cell References in Chapter 11 of the Programming Guide.