Re: Insert error: "Command Execute Insert Multiple step OLE DB operation generate error..."

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Tumurbaatar S. (nospam_tumurbaatar_at_datacom.mn)
Date: 08/10/04 

Date: Tue, 10 Aug 2004 17:18:02 +0900

Thanks all! I found that the Command object
does not clear its Param-s collection when
CommandText is updated. Why did they not
include Clear method for this collection?
There're 2 ways to workaround:
1. remove each item of Param-s manually (e.g in a simple loop)
2. creat a new Command object
I choosed the 2nd one.

> I suggest moving all that logic out of JavaScript and have a stored
> procedure handle the transaction.

Aaron, do you mean that all insert/delete may be moved
into SP? But then how to pass all this values to SP?

Relevant Pages