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:
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.
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:
Is this still relevant if it’s a stored procedure transaction? I’ll go down this path if it is.
Yes. Scripts can run DB stored procedures.