IceViewFetch() |
This subroutine retrieves the next record from a "view" (SQL query) previously opened with a call to "IceViewOpen()".
It returns a record containing all the selected columns of one record or "Nothing" The first column is at index 1 and the "StringData()" and "IntegerData()" methods can be used on each column to retrieve data.
This function takes these parameters:
EXAMPLE |
Please see the "Sample Validation Suite" section for complex examples, a small fragment follows:
do ;--- Get next record, exit at end --- set oRec = IceViewFetch(oView) if oRec is nothing then exit do ;--- Process record --- Component = oRec.StringData(1) ;;1st field in record Attributes = oRec.IntegerData(2) ;;2nd field in record loop