Call MSSQL Stored Procedure from Gateway Event Script

[mdemaris]

Well, my last two posts here are under the wrong thread!
Here is my thread, and I will copy and paste these two posts to that thread.

Calling Stored Procedure

I am attempting to call an SP using a button script event, and testing using a Named Query. Server: MSSQL Button Script: def runAction(self, event): item = self.parent.parent.getChild("Spacer_1").getChild("Label_0").props.text qtyLeft = self.parent.parent.getChild("FlexContainer_2").getChild("QtyLeft_1").props.value userName = self.parent.parent.getChild("FlexContainer_2").getChild("Name_1").props.text comments = self.parent.parent.getChild("FlexContainer_2").getChild("Comments_1").props.…