Stored procedure does not return record set

81 views Asked by At

I have been working on debugging a script. Working through other issues from the first post. I come to a stop at this point where I receive an error @ rst.Open cmd.Execute. This only happens when running stored procedure dbo.BoreRecipe and not dbo.SawRecipe:

'strSql = "dbo.BoreRecipe"
strSql = "dbo.BoreRecipeTest"
'strSql = "dbo.SawRecipe" 

cmd.ActiveConnection = conn
cmd.CommandType = 4 'adCmdStoredProc
cmd.CommandText = strSQL

cmd.NamedParameters = True

'Need to set to parameters in stored procedure
'Set prm = cmd.CreateParameter(@WO, adVarChar, adParamInput, 8)
Set prm = cmd.CreateParameter("@WO")
cmd.Parameters("@WO").Value = sWO

'Get Recordset and Process
rst.Open cmd.Execute

Error Code 800A0BB9

Both stored procedure seem to be of the same formatting. We did add a script to SQL to add a missing value to an existing field of the dbo.BoreRecipie but did not add any other fields. That's about the time this started. It appears the with the On Error Resume Next statement would cause the script to return garbage since there was no information in the record due to the error.

0

There are 0 answers