Stored Procedure / Get more than one Table back

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Hello,

i have a problem with vb6 and SQL Stored Procedures.

The stored procedure deliver more than one Table back. (Query Analyzer) In Basic i want to see that. Can you help?

Example:
Stored procedure bring back:
select * from Test
Select * from Test2

In Basic i see only one Result

Set cda = New ADODB.Command
cda.ActiveConnection = cn_wO
cda.CommandTimeout = 400
cda.CommandType = adCmdStoredProc
cda.CommandText = "sp_TestSP"



cda.Parameters.Append cda.CreateParameter("@debug", adInteger, adParamInput, 50, "1")
cda.Parameters.Append cda.CreateParameter("@TestPar", adChar, adParamInput, 50, "hello")

Set rs_TB = cda.Execute


Greetz

Daniel

.

Relevant Pages

  • Stored procedure Output Parameter headache
    ... I have the following code chunk for a page which accesses an SQL Server 2000 stored procedure that takes an SSN and a Last Name and checks our database for a match. ... Dim cmdDWExport ... .Parameters.Append .CreateParameter("@LastName", adVarChar, adParamInput, 25, txtLName) ... declare @RetMsg varchar ...
    (microsoft.public.inetserver.asp.db)
  • Paul post about stored procedure problems in repliacation
    ... Wrapper stored procedure with @working directory hardcoded ... If I write a wrapper stored procedure for "sp_adddistpublisher" and don't ... cmd.Parameters.Append cmd.CreateParameter("@publisher", adVarChar, ... adParamInput) ...
    (microsoft.public.sqlserver.replication)
  • Re: Stored Procedure runs but displays #Name? in some of the output fi
    ... of the stored procedure. ... Dim cmdSelect As ADODB.Command ... Dim strGLYear As String ... adVarWChar, adParamInput, 1, strMarketChannel) ...
    (microsoft.public.access.formscoding)
  • RE: pass stored procedure parameters in asp
    ... cmdTemp.CommandText = "voidTran" 'stored procedure for exec void ... adParamInput) ... 'attach store procedure parameter ... when I didn't add length in the createParameter, the error message is like ...
    (microsoft.public.inetserver.asp.general)
  • Stored Procedure runs but displays #Name? in some of the output fi
    ... of the stored procedure. ... Dim cmdSelect As ADODB.Command ... Dim strGLYear As String ... adVarWChar, adParamInput, 1, strMarketChannel) ...
    (microsoft.public.access.formscoding)