Click to See Complete Forum and Search --> : Stored Procedures


Goose
October 5th, 1999, 09:26 AM
I am trying to call a stored procedure using DAO.

I am receiving the following error.

Cannot open a cursor on a stored procedure that has anything other than
single select statement in it.

Dim qryReports As New QueryDef

Set qryReports = Connect.DB.CreateQueryDef("", "{call sp_What_"cboQueries.Text & " (?, ?)}")

qryReports.Parameters(0) = cmbAnalyst.Text
qryReports.Parameters(1) = cmbFlag.Text

Set resReports = qryReports.OpenRecordset(dbOpenSnapshot)

Is There A Limitation using DAO ?