Close a Command Object while leaving the Connection Object running
am 13.04.2005 22:49:18 von MSUTechI 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