Creating a table for ERRORCODES

Thu, 18 Aug 2016 09:04:47 GMT

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

topic Creating a table for ERRORCODES in QlikView