Passing transaction group SQL error to screen

Hi All,

Just wondering if there’s any way to grab and pass the error from a transaction group into a tag for the purpose of displaying on the screen?

Example below of what I’m referring to:
image

SQL to throwing back the invalid fill ID fault and I want to pass that out onto an Ignition display if possible.

Appreciate any insight.

Thanks

Edit:- Same issue raised below but didn’t seem to get much of a response:

If you can have such execution problems, I would re-implement the transaction group as a gateway tag change script. Within a script, you can capture then do whatever you like with exceptions.

Edit: See “case 3” in this topic for ideas:

1 Like

Is this still relevant if it’s a stored procedure transaction? I’ll go down this path if it is.

Thanks

Yes. Scripts can run DB stored procedures.