Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
We are running a scheduled task to reload our QVD file from a database every day. The task runs a VB script which keeps retrying every minute until a new QVD has been generated. A new QVD will not be generated until the database is ready. What we have found is that sometimes there is a job running on the database which causes a conflict with the Qlikview reload attempt, and Qlikview gives an indeterminate SQL error message. This means we manually have to click on 'OK' and cancel the reload. It doesn't matter that it gets these errors, because the task will automatically retry until it has succeeded, so we just need a way to surpress the SQL Error messages in Qlikview. Does such a feature exist? Something like, on error, automatically close? Thanks.
Try something like this
set ErrorMode=0; or set ErrorMode=4 or 5 ; or see help on ErrorMode
If ErrorMode = 4 then
.......
Endif
Talha
Try something like this
set ErrorMode=0; or set ErrorMode=4 or 5 ; or see help on ErrorMode
If ErrorMode = 4 then
.......
Endif
Talha