Stored procedure returns no records - handling error message.
Posted on 2004-10-11
In my ADP I have a form with button. When the button is clicked, a stored procedure is run that updates a table in the SQL Database. This is what I want it to do, and it works just fine. BUT, I also get a popup box that reads "stored procedure executed but did not return records". Click OK and it goes away, but I'd prefer if it didn't appear at all, since I'm not expecting my stored procedure to return records.
I'm calling the SP with DoCmd.OpenStoredProcedure
Perhaps there is another way to call it so that it doesn't expect to return records?
Or, is there a way to suppress the error message? I can't figure out what the error number is. I put in error handling code but it's not being caught by that.