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

---

IceViewOpen()

This function performs an SQL query (handles all error reporting) and opens a "view".

The "view" handle is returned by this function and should be passed to "IceViewClose()" when you have finished with it.

It is best to validate the existance of all tables you might be using with code similar to the following:

if  Database.TablePersistent("Component") <> 1 then
    IceDebug("There is no ""Component"" table so exiting validation!")
else
    ;--- Do stuff ---
end if

This function takes these parameters:

1. An SQL Query.

EXAMPLE

Please see the "Sample Validation Suite" section for complex examples, a small fragment follows:

set oView = IceViewOpen("SELECT `Component`, `Directory_`, `Attributes`, `KeyPath` FROM `Component`")
if  oView is Nothing then exit sub
do
   ;--- Get and process records ---
loop
IceViewClose(oView)

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). Saturday May 28 2022 at 3:11pm Visit MAKEMSI's Home Page