Error variables¶
ErrorMode¶
The error variable determines what action is to be taken when an error is encountered during script execution.
ErrorMode
| Argument | Description |
|---|---|
| ErrorMode=1 | The default setting. The script execution will halt and the user will be prompted for action (non-batch mode). |
| ErrorMode=0 | The engine will simply ignore the failure and continue script execution at the next script statement. |
| ErrorMode=2 | The engine will trigger an "Execution of script failed..." error, without prompting the user for action beforehand. |
ScriptError¶
This error variable returns the error code of the last executed script statement.
ScriptError
This variable will be reset to 0 after each successfully executed script statement. If an error occurs it will be set to an internal error code. Error codes are dual values with a numeric and a text component. The following error codes exist:
| Error code | Description |
|---|---|
| 0 | No error |
| 1 | General error |
| 2 | Syntax error |
| 3 | General ODBC error |
| 4 | General OLE DB error |
| 5 | General custom database error |
| 6 | General XML error |
| 7 | General HTML error |
| 8 | File not found |
| 9 | Database not found |
| 10 | Table not found |
| 11 | Field not found |
| 12 | File has wrong format |
| 13 | BIFF error |
| 14 | BIFF error encrypted |
| 15 | BIFF error unsupported version |
| 16 | Semantic error |
Example:
set ErrorMode=0; LOAD * from abc.qvf; if ScriptError=8 then exit script; //no file; end if
ScriptErrorCount¶
This error variable 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.
ScriptErrorList¶
This error 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.
