Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

Creating a table for ERRORCODES

Hi

I want to create a table that will tell me something about errorcodes, I have set ErrorMode = 0;

I have tried a couple of different solutions, here is the one using a Sub:
         

     Load * From table.qvd (qvd);

       If '$(#ScriptError)' <> 0 Then

            Call ErrorCode('$(#ScriptError)', '$(ScriptError)', '$(ScriptErrorDetails)');

  

       End If;

     Sub ErrorCode(vScriptErrorNumber, vScriptError, vScriptErrorDetails)

            ErrorLog:

            LOAD

            '$(vNameOfStock)'           As Ticker,

            '$(ScriptErrorCount)'         as ScriptErrorCount,

            vScriptErrorNumber          as ScriptErrorNo,

            vScriptError                     as ScriptError,

            vScriptErrorDetails           as ScriptErrorDetails

            AutoGenerate(1);

     End Sub;

It does not work..

//*****************************************************************


This one does work, but I dont find it very flexible or usable as I will need it many places in my script:

     If '$(#ScriptError)' <> 0 Then


                 ErrorLog:

                 LOAD

                 '$(vNameOfStock)'           As Ticker,

                 '$(ScriptErrorCount)'         as ScriptErrorCount,

                 '$(#ScriptError)                 as ScriptErrorNo,

                 '$(ScriptError)                  as ScriptError,

                 '$(ScriptErrorDetails)        as ScriptErrorDetails

                 AutoGenerate(1);

     End If;

I have read that the error codes are only available right after the occur, is that correct?

I have also read all threads I could find on the subject....

Best regards
Espen

Community Browser