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:
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)