topic Re: How to exit while script fails? in QlikView

How to exit while script fails?

Wed, 12 Aug 2015 12:16:41 GMT

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.

Re: How to exit while script fails?

petter — Wed, 12 Aug 2015 12:19:45 GMT

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

Re: How to exit while script fails?

petter — Wed, 12 Aug 2015 12:20:42 GMT

ScriptError

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