MAKEMSI quickly and reliably creates MSI files in a non-programmatic way
Have your say! Join the MAKEMSI discussion list or view archive! Suggest improvements. No question too simple or too complex.
[Bottom][Contents][Prev]: IceViewFetch()[Next]: IceWarning()
Have your say! Join the MAKEMSI discussion list or view archive! Suggest improvements. No question too simple or too complex.
\->MAKEMSI Installs...->Available Frameworks->Validation Suites (create CUB files)->Functions - ICE->IceViewOpen()

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)


Microsoft awarded me an MVP (Most Valuable Professional award) in 2004, 2005, 2006, 2007, 2008 & 2009 for the Windows SDK (Windows Installer) area.Please email me any feedback, additional information or corrections.
See this page online (look for updates)

[Top][Contents][Prev]: IceViewFetch()[Next]: IceWarning()


MAKEMSI© is (C)opyright Dennis Bareis 2003-2008 (All rights reserved).
Saturday May 28 2022 at 3:11pm
Visit MAKEMSI's Home Page
Microsoft awarded me an MVP (Most Valuable Professional award) in 2004, 2005, 2006, 2007, 2008 & 2009 for the Windows SDK (Windows Installer) area.