Retrieving Information about a Table Field

Formname identifies the form in which the table field is displayed. If formname is left as an empty or blank string and tablename is not specified after the constant, then the constant refers to the current table field in the current form. This form of the statement is particularly useful while displaying a table field or while in the formdata loop. You can express both formname and tablename as quoted or unquoted string literals or as program variables.

Note: To determine if a specific table field exists, use the inquire_frs field (exists) option, described in the section entitled Retrieving Information About a Field. To determine if a particular column in a table field exists, use the inquire_frs column (exists) option, described in Retrieving Information about a Column.

Frs_constant	Data Type	Returns
column	character	Returns the name of column on which the cursor is positioned within the table field.
datarows	integer	Returns the number of non-deleted rows stored in the data set of the table field. If the table field is not linked to a data set, then this is equivalent to lastrow.
lastrow	integer	Returns the number of displayed rows on the table field that actually contains data.
maxcol	integer	Returns the number of displayed columns in the table field as defined in VIFRED, including any currently invisible columns.
maxrow	integer	Returns the number of displayed rows within the table field, as defined in VIFRED.
mode	character	Returns the table field initialization mode (fill, update, query, or read).
name	character	Returns the name of the table. Because this constant always refers to the current table field, it is not necessary to specify a tablename.
rowno	integer	Returns the current row number within display (displayed rows are numbered from 1).