VB Forum / Database Access / March 2005

Hi,
If I want to call the same stored procedure several times - each time
replacing the parameters, do I need to delete the parameters
collection between each call?

Example - After I do this:
 cmd.Parameters.Append cmd.CreateParameter("ID", adInteger,
adParamInput, , ID1)

cmd.Parameters.Append cmd.CreateParameter("name", adInteger,
adParamInput, , Name1)

 cmd.Parameters.Append cmd.CreateParameter("Address", adInteger,
dParamInput, , Address1)
       
           cmd.Execute  

Do I need to do this before I can call the SP again with a new set of
parameters?:
cmd.Parameters.Delete "ID"
cmd.Parameters.Delete "Name"
cmd.Parameters.Delete "Address"

Or, will the creating a new set of parameters for the subsequent
replace the existing ones?

Thank you.