Stefan Berglund wrote:You don't have to set it to nothing> I was looking for a general consensus as to whether the
> ActiveConnection property of the command object should be set to
> Nothing or whether it's sufficient to set the command object itself
> to nothing.
Since your stored procedure has no output parameters, and you don't seem to>
> I also seem to be forced to use the Parameters.Append method, since I
> was unable to make the statement Set rs =
> .Execute(,Array(strShowID,strSort),adCmdStoredProc ) work without
> I'm guessing that while they're both Variants, one is a numeric and
> the other a string? The above statement yields :
> Parameter object is improperly defined. Inconsistent or incomplete
> information was provided.
be interested in reading the value of the Return parameter, I suggest you
don't use an explicit Command object at all. Try this (assuming your
connection object variable is called cn):
cn.show_ShowEntries strSort, rs
If you're executing a procedure that does not return records, just leave off
the rs argument:
cn.NoRecords parmval1, ..., parmvalN
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.