\
MAKEMSI Installs...
Available Frameworks
Validation Suites (create CUB files)
Functions - ICE
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:
- An SQL Query.
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)