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 ?
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 ?