This error variable returns the error code of the last executed script statement.
Syntax:
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 Qlik Sense 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