Command object

[transparent]

Is there a way to clear the command object?

i.e. I'm using stored procedures in sql server and the data seems to be corrupted from the previous stored procedure

HElp!!!!

Cheers

 

[hereyago]

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/ado270/htm/mdobjcommand.asp

One option is to use a new command object each time.