17. Forms Statements : inquire_frs Statement—Retrieve FRS Runtime Information : Retrieving Information About a Row in a Table Field
 
Share this page                  
Retrieving Information About a Row in a Table Field
The row object type can be used to retrieve information about a row within a table field. The syntax is:
inquire_frs row formname tablename [row_number]
    (variable = frs_constant[(columnname)]
     {, variable = frs_constant [(columnname)]});
Formname identifies the form which contains the specified table field, and columnname identifies the column in the table field. If formname and tablename are left as empty strings and no columnname is specified after a constant, the table field cell on which the cursor is currently resting is assumed.
Valid values for frs_constant are listed in the following table:
Frs_constant
Data Type
Comment
change
integer
Returns to 1 if the user has typed into the column, 0 otherwise. To set the change variable for the column, use set_frs. A field's change variable is set to 1 when the runtime user types into the column. It is set to 0 at the start of a display loop, when a value is placed into the column by a putrow statement, when the column is cleared by a clear statement, or when a new row is created as with an insertrow statement. To inquire about a particular displayed row, specify row_number; to specify the current row, omit row_number. In an unloadtable statement loop you cannot specify row_number, and therefore can only inquire on the row just unloaded.
display
integer
Returns 1 if the specified display attribute is turned on for the specified cell (row and column). For color, returns color code (0 - 7) Display must be one of the following:
blink
color
intensity
normal
reverse
underline
startrow
integer
The starting row coordinate for the current input cell of a table field. This coordinate is relative to the terminal screen coordinates. The terminal screen's origin is its upper left hand corner, described as 1,1. If the value returned by startrow is zero or negative, then the input cell's starting row is off of the screen. A zero is also returned if the inquire_frs statement is issued from an activate scroll up/down block.
startcolumn
integer
The starting column coordinate for the current input cell of a table field. This coordinate is relative to the terminal screen coordinates. The terminal screen's origin is its upper left hand corner, described as 1,1. If the value returned by startcolumn is zero or negative, then the input cell's starting column is off of the screen. A zero is also returned if the inquire_frs statement is issued from an activate scroll up/down block.
To determine if a display attribute is turned off or on for a particular value in the table field data set, you must use the inquire_frs statement within an unloadtable loop. Omit the row_number parameter: statements within an unloadtable loop always operate on the current row.