Re: Error when Reusing ADO Connection & Command

MarketWizard wrote:
Hello,
it fails on the execute command within the body of the loop.
the main question is: how can you re-use a command within the body of
a loop, where with each iteration, the parameters to the stored
procedure change. I am calling a stored procedure which returns a
ref cursor. How should I re-use the connection, command, recordset?
I have tried to move the creation&closing of these within the loop,
and received the same 'missing expression' error.

any idea on best practices on this? and what may be invalidating my
command (which is what I suspect is going on) thanks much in advance


I'm not sure it has anything to do with your error, but this:
cmd2.ActiveConnection = cn

should be:
Set cmd2.ActiveConnection = cn

--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.


.

Relevant Pages

  • Sol8 and EVA hangs
    ... Secure Path 3.0D is loaded for channel failover. ... retrying command ... # Adapter hard loop ID address to use on the fibre channel bus. ...
    (SunManagers)
  • Summary: Sol8 and EVA hangs
    ... Oct 8 11:00:41 proddb SCSI transport failed: reason 'aborted': ... retrying command ... # Adapter hard loop ID address to use on the fibre channel bus. ... # before reporting I/O errors. ...
    (SunManagers)
  • Re: Using foreach loop to create radiobutton menu
    ... Your foreach loop is not the problem, the problem is how you define the -command. ... The only possible thing the interpreter can do is substitute the current value of range, which is likely the last value once your loop exited. ... One choice is double quotes. ... The double quotes means that $range gets expanded while in the loop, long before the puts command actually runs. ...
    (comp.lang.tcl)
  • Re: Issue implementing Runtime.exec() with StreamGobbler
    ... So jloader basically calls LoaderAutomationRun.java (starts the loop) ... As you can see the last line, the New Command Executer never returned. ... If your test driver is hanging, I'd guess that the test process itself is ...
    (comp.lang.java.programmer)
  • Re: What does Ctrl+C really do
    ... loop) to fgetsthe user's commands. ... As posted before there is a signal handler taking care of that. ... I interprete "windows terminal" as a Command Shell in MS-WIndows, ... Shell detects that the telnet client has been gone it terminates itself. ...
    (comp.os.vxworks)
Quantcast