A_X_L_V wrote:You cannot "suppress" recordsets returned by a procedure. You COULD revise> Hi,
> I've ran into a small dilemma.
> I use ADO to get Recordset from Stored Procedure.
> We use generic function written in VBScript to retrieve last Recordset
> returned by it.
> One of our stored procedures calls another stored procedure, which
> also returns a recordset.
> That causes a problem, because now ADO returns 2 recordsets instead
> of 1, and our generic data access function fails.
> I'd like to find a way of suppressing all recordsets except one inside
> stored procedure.
> I can't change VBscriptc function, because it's used by more than one
> Just a thought, I've tried SET NOCOUNT, and it doesn't work in the
> above situation.
the vbscript code so that the "wrong" recordset is ignored, but you say you
want to avoid this, leaving only one alternative: you will have to rewrite
the procedure so it only returns a single resultset
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.