Posted by Erland Sommarskog on 09/30/69 11:16

(jennifer1970@hotmail.com) writes:
> I thought I had it worked out. And I am almost positive that once I
> write it all down here I'll see where I am going wrong. :) I thought
> I'd use a cursor and loop through the repeaters and renumber them.
> BUT.... I never seem to get out of the second cursor loop. It hangs
> there and keeps renumbering the first record over and over again. It
> looks like @@FETCH_STATUS is always zero.
>
> Any ideas?

Try adding INSENSITIVE before CURSOR. That finalizes the result set for
the cursor once for all. The default keyset-driven cursors may pick
up your updates and feed you back the row you just changed.



--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp

[Back to original message]