topic Errors in Load script in QlikView

Errors in Load script

jduenyas — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: Errors in Load script

eduardo_dimperio — Mon, 21 Aug 2017 19:01:17 GMT

Hi Josh,

Use ErrorMode=0

Error Handling in Qlikview

Re: Errors in Load script

jduenyas — Mon, 21 Aug 2017 19:13:13 GMT

Wonderful!

Thanks

Re: Errors in Load script

eduardo_dimperio — Mon, 21 Aug 2017 19:18:13 GMT

Any time Josh

Re: Errors in Load script

jduenyas — Mon, 21 Aug 2017 19:27:08 GMT

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

Thanks anyways

Re: Errors in Load script

eduardo_dimperio — Mon, 21 Aug 2017 20:17:52 GMT

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.

Re: Errors in Load script

zsbaksa — Tue, 03 Nov 2020 08:36:08 GMT

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.