Does anyone have an example of using “Execute Non Query” to call a stored procedure that uses its Return Code to return a result?
For example, let’s say I have stored proc “TheAnswerToTheUniverse_sproc” defined as
CREATE PROCEDURE TheAnswerToTheUniverse_sproc
I call it with “Execute Non Query”, attempting to put the Return Code in a variable named “anInt”
But all I get back is “-1” : “The answer to the Universe is -1”
The other posts I’m reading and the documentation seems to suggest that the Affected Records attribute is just for calls that do things like INSERT, DELETE, etc. So if there’s some way to get back the Return Code, I’d love to hear about it.