Get error message from SP SQL Server. display message with error type

I Need to get the error message from and SP or a Transaction and use it with Ignition. for example.

if we have a duplicate fail insert, i want to catch that error , identify it, and then display an error message box saying ’ Can’t insert a duplicate name’. if the error was for example something different, then do the same and display a different message like for example: ‘Can’t insert the a negative value into Cases amount’.

a way to do this would be to pass the Message Error into an Out parameter, but the problem is that ignition won’t let me use the Out parameter if an SP it’s rolled back.

Any ideas on how to achieve this?

1 Like

I have the exact same issue. Did you come up with a resolution? I notice no replies, unfortunately. Thanks, David

Check: DB Tables and Unique or duplicate values