Miscellaneous Statements
To sequence through all the columns in a table field, inquiring on each one, use the tabledata loop.
To validate table fields use the following statements:
validate
Validates all columns and rows of displayed data
validrow
Validates only the data in a single, specified row. Rows of data are automatically validated when they are scrolled out of the table field's display window. See
How Field Validation Works for a full discussion of FRS validation operations.
To clear rows of data use the following statements:
clear
Removes all rows from a data set, including rows, which are not currently visible. Because the data set continues to store values even after the end of a form's display, the clear statement provides a convenient method for clearing out the table field display before redisplaying the form. The only other way to remove all values from the data set is to issue a second inittable statement before redisplaying the form, which causes a new, empty data set to overwrite the original one.
clearrow
Clears a single displayed row. Unlike the deleterow statement, which deletes the row from the display and compacts the remaining rows, clearrow does not delete the row, but merely clears its values.
For detailed descriptions of these statements, see
Forms Statements.