GML::FIND - Retrieve Lowest -Numbered Empty Row
Syntax
CALL "GML::FIND"
Description
This procedure retrieves the lowest numbered empty row in a grid. The retrieved row number is placed into the GML_TPL$ template variable GML_TPL.ROW_N%. A GML_TPL.ROW_N% value of –1 indicates no rows are empty within the selected grid.
Options
The FIND procedure normally moves the highlighted cell in a main grid to the empty row (if found). Setting GML_TPL.DEF_FLAG% to a value of 1 will find an empty row but not move the highlighted cell to that row.
The FIND procedure considers a cell containing only spaces as a cell that contains text. If variable GML_TPL.SUP% is set to 1 when executing the FIND procedure, the VPRO/5 CVS function will be used to strip spaces. When this option is used, a cell containing only spaces will be considered as an empty cell.
Example
2400 GML.SET%=1
2410 CALL "GML::TPL_PREP"
2420 CALL "GML::FIND"