MAKEMSI quickly and reliably creates MSI files in a non-programmatic way\MAKEMSI Installs...Available FrameworksValidation Suites (create CUB files)Functions - ICEIceViewFetch()

---

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:

1. A "view" handle previously returned by a call to "IceViewOpen()".

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

Please email me any feedback, additional information or corrections. See this page online (look for updates) MAKEMSI© is (C)opyright Dennis Bareis 2003-2008 (All rights reserved). Thursday August 28 2008 at 11:28am Visit MAKEMSI's Home Page