The values of all five variables will remain after script execution. The value of the last four variables, for error handling inside the script, is of course dependent on the use of ErrorMode=0.
This variable determines what action is to be taken by QlikView when an error is encountered during script execution.
By default (ErrorMode=1) the script execution will halt and the user will be prompted for action (non-batch mode).
By setting ErrorMode =0 QlikView will suppress all error messages on failure to load. If script execution is halted due to failure, it will not continue.
By settingErrorMode =2 QlikView will trigger an "Execution of script failed..." error message immediately on failure, without prompting the user for action beforehand.
Returns the error code of the last executed script statement. This variable will be reset to 0 after each successfully executed script statement. If an error occurs it will be set to an internal QlikView error code. Error codes are dual values with a numeric and a text component. The following error codes exist:
General ODBC error
General OLE DB error
General custom database error
General XML error
General HTML error
File not found
Database not found
Table not found
Field not found
File has wrong format
BIFF error encrypted
BIFF error unsupported version
load * from abc.qvw;
if ScriptError=8 then
Returns a more detailed error description for some of the error codes above. Most importantly this variable will contain the error message returned by ODBC and OLE DB drivers for error codes 3 and 4.
Returns the total number of statements that have caused errors during the current script execution. This variable is always reset to 0 at the start of script execution.
This variable will contain a concatenated list of all script errors that have occurred during the last script execution. Each error is separated by a line feed.