Problem in Stored Procedure

Question

jugnu 0 Newbie Poster

13 Years Ago

Hello,

I am having problem in calling Stored Procedure second time while remaining on the Entry Form. I have attached a word file having screen shots and code snippet

Thanks

This attachment is potentially unsafe to open. It may be an executable that is capable of making changes to your file system, or it may require specific software to open. Use caution and only open this attachment if you are comfortable working with msword files.

StoredProcedureProblem.doc (355.5 KB)

2 Contributors
3 Replies
84 Views
9 Hours Discussion Span
Latest Post 13 Years Ago Latest Post by Momerath

Momerath 1,327 Nearly a Senior Poster

13 Years Ago

I suspect that it has to do with you never destroying the Command object. You've already added parameters to it once, and next time through you add even more parameters, thus the error.

Reply to this topic

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.

jugnu 0 Newbie Poster · Answer 1 · 2011-02-14T15:57:08+00:00

Will Command.Dispose() work? or something else has to be done? after disposing the command object the problem is still there :(

Momerath 1,327 Nearly a Senior Poster Featured Poster · Answer 2 · 2011-02-14T16:05:15+00:00

Will need to see more of your code. You have too many globals to tell everything that is happening.