Close a Command Object while leaving the Connection Object running

Close a Command Object while leaving the Connection Object running

am 13.04.2005 22:49:18 von MSUTech

I have a connection object open....

within that, I am creating a command object that is a stored procedure with
about 25 parameters. This stored procedure will be run about 10 times within
one loope.... but, when the loop starts running and I am appending parameters
to the command object... it tells me that I have too many parameters....

so, Can I do the following, if so, how?

Connection Object OPEN

For I=1 to 25

Command Object Open
Create & Append Parameters
Run Stored Procedure
Close Command Object

Next

Connection Object.Close

Thanks

--

Systems Programmer