Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
how to exit while script fails?
Ex: I have application when i am loading data into the script getting error and loading loaded data which is error data not loaded.
But my question is When i am loading loading if i get error loading data i need exit or trace the error for that need code.
Help me plz.
Ramya.
You should set the Error Variable ErrorMode to 0 and then test the ScriptError variable for which return code was raised from the load statement.
Example:
set ErrorMode=0;
load * from abc.qvw;
if ScriptError=8 then
exit script;
//no file;
end if
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:
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 |