Cannot Update Cursor Records !?

[dougcoulter]

I think I am losing my mind. I have a stored procedure using a cursor (in SQL 7.0) to update some records (and I swear it was working yesterday!), but I now am receiving the following message for each record update attempt:

Server: Msg 16947, Level 10, State 1, Line 32334296
No rows were updated or deleted.
The statement has been terminated.

The statements in question are:

UPDATE OpModeHistory
SET Occurrence = 2
WHERE CURRENT OF OpModeCursor

I do not seem to have any syntax issues. Any ideas?

Thanks...

 

[tlbroadbent]

Check this article.

http://support.microsoft.com/support/kb/articles/Q238/5/47.ASP

Terry L. Broadbent
FAQ183-874 contains tips for posting questions in these forums.
NOTE: Reference to the FAQ is not directed at any individual.

 

[dougcoulter]

Thanks for the response. My cursor is based on a simple select on a single table though.