ado recordsets from stored procedures, stored procedures have input parameters
ado recordsets from stored procedures, stored procedures have input
parameters
i have a sql server (7.0) stored procedure
i want to create an ado recordset off the stored procedure
..
the .sql is
Create PROC usp_10_return_authors_upperlevel
AS
return
GO
and my current vb/ado code is
Private Sub Command1_Click()
On Error GoTo errorhandler:
Dim cn As ADODB.Connection
Dim rs As ADODB.Recordset
Set cn = CreateObject("ADODB.Connection")
cn.Open "Provider=SQLOLEDB.1;Persist Security Info=False;User ID=sa;Initial
Catalog=pubs;Data Source=."
Set rs = cn.Execute("EXEC usp_10_return_authors_upperlevel 'a'")
While Not rs.EOF
MsgBox rs.Fields(0).Value
rs.MoveNext
Wend
Set rs = Nothing
Set cn = Nothing
Exit Sub
errorhandler:
MsgBox Err.Number & " " & Err.Description
End Sub
..
it cracks on this line
Set rs = cn.Execute("EXEC usp_10_return_authors_upperlevel 'a'")
if i use
Set rs = cn.Execute("EXEC usp_10_return_authors_upperlevel"), it tells me i
don't have the parameter
how do i pass in the parameter??
..
sloan
been acting weird)
