\
MAKEMSI Installs...
Available Frameworks
Validation Suites (create CUB files)
Functions - ICE
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:
- A "view" handle previously returned by a call to
"IceViewOpen()".
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