Database query capture the error

[jingwang0222 (Jing Wang)]

Hi ALL

I am working on query database and write the value, but the situation is,
when I use the “Execute Query” activity, there is property “ContinueOnError”, it is set as “True” so that even error happens the process can continue.

But the problem is, I would like to have the error been highlighted as a strange value so I can identify it immediately, but this activity did not provide this function, any handy idea to do this?

Thanks

[supermanPunch (Arpan)]

@jingwang0222 You Should set ContinueOnError Property to False

[jingwang0222 (Jing Wang)]

Hi Thanks for your reply, because the query is long, my assumption is: while it is “True”, any solution to capture the error occurred?

[supermanPunch (Arpan)]

@jingwang0222 Have you tried using a Try Catch Activity ?

[Manish540 (Manish Shettigar)]

You can put your execute query in try catch and check.

[jingwang0222 (Jing Wang)]

Hi Thanks for the advice

but as the official web said
" If this activity is included in Try Catch and the value of the ContinueOnError property is True, no error is caught when the project is executed."

[Manish540 (Manish Shettigar)]

Make ContinueOnError property as False and check.

[AshwinS2 (Ashwin S)]

Hi @jingwang0222

Give all the available parameters and based on that you can set the continue on error as falseand check whether the activity is within try catch block

Thanks
Ashwin S

[jingwang0222 (Jing Wang)]

Hi All

Thanks for the help, problem solved, I add another execute query to give a dummy initial value for every result I required, then if the real execute query get the right value, it will be overwrote, if error, it will be dummy value/empty.