Hi I am trying to use the stored procedure command in a delete button on my template.
The template is correctly showing the "COUNTID" and returns the list correctly.
However when I try and use the "COUNTID" in the following delete stored proc I get an error.
----------------------------------------------
<DeleteCommand CommandText="spDELETE_COUNT" CommandType="StoredProcedure" ConnectionString="[[ConnectionString:CountDatabase]]">
<Parameter Name="COUNTID" />
</DeleteCommand>
----------------------------------------------------
Error
Procedure or function 'spDELETE_COUNT' expects parameter '@COUNTID', which was not supplied.
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.
Many thanks
Mark