XModPro

Strange Issue with Stored Procedure and DeleteCommand

Steve Krantzman Steve Krantzman asked Jan 30, 2019
Active Feb 8 · Viewed 1158 times
<p>I have a strange issue in my XMP Template where in my DeleteCommand, while utilizing a Stored Procedure, I get an error telling me that the SP is expecting a parameter that I am providing. Yet when I change the Command Text to a straight forward DELETE statement, it works fine with the parameter. </p> <p>See Fiddle:<br><a href="http://dnndev.com/fiddle/fid/744">http://dnndev.com/fiddle/fid/744</a><br> </p> <p>Also if I run the SP manually in SSMS, it executes without an issue. </p> <p>Am I doing something wrong? </p>

1 Answer

Loading answers...