XModPro

Stored Procedures

Mark Trippier Mark Trippier asked Aug 11, 2015
Active Dec 15 · Viewed 1511 times
<p>Hi I am trying to use the stored procedure command in a delete button on my template.</p><p>The template is correctly showing the "COUNTID" and returns the list correctly.</p><p>However when I try and use the "COUNTID" in the following delete stored proc I get an error.</p><p>----------------------------------------------</p><p>&lt;DeleteCommand CommandText="spDELETE_COUNT" CommandType="StoredProcedure" ConnectionString="[[ConnectionString:CountDatabase]]"&gt;<br> &lt;Parameter Name="COUNTID" /&gt;<br> &lt;/DeleteCommand&gt;</p><p>----------------------------------------------------</p><p>Error<br><br>Procedure or function 'spDELETE_COUNT' expects parameter '@COUNTID', which was not supplied.</p><p>Can anyone point out what I'm doing wrong please, have tried as many options as possible using the help file and still cant work it out.</p><p>Many thanks</p><p>Mark</p>

1 Answer

Loading answers...