I am trying to write an error handler so we can see when stored procedures in our MS SQL 2005 backend occur. To do this, I’m using plugins.rawSQL.getException()
However, it’s returning an error when no error occurs. Picture attached – you can see from the dataset variable that the proc succeeded and returned data. But the exception shows up in my SPerror variable nonetheless.
To be clear, this is a real SQL exception that I was getting earlier for good reason. Parameter 3 was not set. But now the error is hung somehow in the getException command – quitting servoy developer and relaunching doesn’t solve this. It comes back even though the problem is solved and the proc is fine.
