how to suppress sp execution results when form loads?

[embryo]

I have a command button on a form with an event procedure that fires off a stored proc that updates any records whose value is "Promised" to "Broken Promise" if they do not pay by the PromiseDate value.. it then opens a form which allows them to buiild the criteria for reports.

The problem is that if there are no records to update, a pop-up with the following text occurs and I'd like to learn how to suppress it.

"The stored procedure executed successfully but did not return records."

Anyone??

Thanks,


Steve
---------------------------------------
IF WebApplicationProgrammer = True Then
ElectronicSheepHerder = True
End If

 

[Hfnet]

Just a guess....

DoCmd.SetWarnings = False
Call your stored procedure
DoCmd.SetWarnings = True

 

[payback]

I think there is a SQL command you can put in your stored procedure but I can not remember it (or find it at the moment - doesn't that always happen). I suggest you repost this question in the SQL forum - I am sure someone there will know it.

 

[payback]

I've found it now.

Transact-SQL includes the SET NOCOUNT statement. When the NOCOUNT option is set to ON, SQL Server does not return the counts of the rows affected by a statement.

Not sure if this is the right one for you but.....