Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
jduenyas
Specialist
Specialist

Errors in Load script

Gurus

When performing a query in SQL Studio, a general error is being returned but the Query finishes and a recordset is being returned.

When running the same in the Load Script of QV, the process breaks. (Naturally)

Is it possible to turn off error warnings so that the script will continue to the end?

Thanks

1 Solution

Accepted Solutions
eduardo_dimperio
Specialist II
Specialist II

6 Replies
eduardo_dimperio
Specialist II
Specialist II

Hi Josh,

Use ErrorMode=0


Error Handling in Qlikview

jduenyas
Specialist
Specialist
Author

Wonderful!

Thanks

eduardo_dimperio
Specialist II
Specialist II

Any time Josh

jduenyas
Specialist
Specialist
Author

And just realized that turning warnings off is BAD PRACTICE !!!!

Thanks anyways

eduardo_dimperio
Specialist II
Specialist II

Depends,

I use a rest connection to get 250.000 adress from google, imagine if i have some connections problem in one of this searchs and lost everything?  So, to my reality its a good choice, but sometimes is not,cause it could hide some problem in your code.

zsbaksa
Contributor II
Contributor II

I think the best practice here is to set the ErrorMode=0 only before that line which is questionable (the line that may drop error). After that the ErrorMode should be set back to 1.