Discussion Board for collaboration on QlikView Scripting.
I try to manage error from my appli and I have a question for ScriptErrorDetails:
Why did he turn "NULL" after an error ?
LOAD * INLINE [
STORE Datas Into (txt);
First 1 LOAD
'$(NbRows)' as NB_ROWS,
'$(ScriptErrorCount)' as ERROR_SEQ_NUMBER,
'$(#ScriptError)' as ERROR_ID,
'$(ScriptError)' as ERROR_NAME,
'$(ScriptErrorDetails)' as ERROR_DETAIL,
'$(ScriptErrorList)' as ERROR_LIST,
now() as ERROR_DATE
STORE TEMP2 into ../DATA/TABLES/TEMP2.qvd(qvd);
This way ScripErrorDetails will keep the Error and when the problem come from unnamed fields the error don't stay in ScripErrorDetails.
Go to Solution.
It's explained within the help by ERRORMODE that ScriptErrorDetails will be only filled by certain errors most from odbc-driver or databases.
This is tricky. You should remember that ScriptError-variables are reset when the next statement is executed.
On the other hand, what exactly should QV tell you about "unnamed fields"?
Thanks for your help.
I wanted to tell "field not found <A>" sorry.
Only ScriptErrorName and ScriptErrorDetails are empty, ScriptErrorList still have his error
Someone know why ScriptErrorDetails get an error when this error is a "Table not found " and when it's "field not found <A>" ScriptErrorDetails get nothing.
These two parts have the same script:
The only difference this script is under different script with an error I made:
First: "Table not found" - I store a table who doesn't exist
Second: "field not found <AH>" - I changed a field who doesn't exist