17. Forms Statements : inquire_frs Statement--Retrieve FRS Runtime Information : Retrieving Information about a Table Field
 
Share this page                  
Retrieving Information about a Table Field
The table object type retrieves information about a table field. The syntax is:
inquire_frs table formname
     (variable = frs_constant[(tablename)]
     {,variable = frs_constant[(tablename)]})
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.
The legal values for frs_constant are listed in the following table:
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).