topic Re: Fetch Error code value in the variable in QlikView

Fetch Error code value in the variable

Anonymous — Wed, 29 Nov 2017 16:23:23 GMT

Good day!
Can anyone advice please, if is it possible to fetch script error code in the variable?
Like:
Set vCheck=ScriptError

if(vCheck=0) then

//Continue

Else

//Stop

End if

Thanks.

Re: Fetch Error code value in the variable

YoussefBelloum — Wed, 29 Nov 2017 16:30:19 GMT

read the comment of MLH Group James‌ on this Re: Error handling in script

Re: Fetch Error code value in the variable

el_aprendiz111 — Wed, 29 Nov 2017 17:28:35 GMT

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

SET ErrorMode = 0;

LOAD * FROM mydfile.qvd (qvd);

IF ScriptError>1 AND ScriptError<>8 THEN
TRACE File not found;
ELSE
TRACE File loaded;
END IF

SET ErrorMode = 1;

Re: Fetch Error code value in the variable

rwunderlich — Wed, 29 Nov 2017 18:17:22 GMT

Yes. To get the number of the script error:

LET vCheck=num(ScriptError);

to get the text of the ScriptError:

LET vCheck=ScriptError;

-Rob

http://masterssummit.com

http://qlikviewcookbook.com

Re: Fetch Error code value in the variable

Anonymous — Thu, 30 Nov 2017 09:04:51 GMT

Thanks, Rob!