Re: Stored Procedures & Parameters Insert Problem

Hi Bob,

Well, I thought I had tried experimenting with the Command's Prepared
property... I have just gone back to the code, after having a doubt in
the back of my mind, and tried changing the Prepared property to True,
prior to executing the loop, and it worked.

Although I am glad that this has worked, I cannot understand why.
Does this mean that only compiled stored procedures will check for new
parameter values upon each execution?

Many thanks for your help Bob.


Regards,

Mike

.