sql 游标 报错 FOR UPDATE cannot be specified on a READ ONLY cursor

[sff_666]

我用游标更新数据 报错
FOR UPDATE cannot be specified on a READ ONLY cursor??
---------------------------------------
Declare @TT VARCHAR(100),@Year int,@ii int
Declare cMain_cursor CURSOR FOR
select X from P_A
FOR UPDATE OF X
OPEN cMain_cursor
FETCH FROM cMain_cursor
INTO @TT ,@Year
SET @ii = 1
While @@FETCH_STATUS = 0
BEGIN
PRINT CAST(@II AS VARCHAR)+'----'+@TT
update P_BookLits set X = '1'
where CURRENT OF cMain_cursor
SET @ii = @ii + 1
FETCH NEXT FROM cMain_cursor
INTO @TT,@Year
END
CLOSE cMain_cursor
DEALLOCATE cMain_cursor


请高手指点？？

[fuda_1985]

。。。你要update的地方是只读的。

[sff_666]

怎么改呀？是该数据库么？

[sff_666]

sorry !
语句是这样的
Declare @TT VARCHAR(100),@Year int,@ii int
Declare cMain_cursor CURSOR FOR
select X from P_A group by X ---------------------------------"有个分组！"
FOR UPDATE OF X
OPEN cMain_cursor
FETCH FROM cMain_cursor
INTO @TT ,@Year
SET @ii = 1
While @@FETCH_STATUS = 0
BEGIN
PRINT CAST(@II AS VARCHAR)+'----'+@TT
update P_BookLits set X = '1'
where CURRENT OF cMain_cursor
SET @ii = @ii + 1
FETCH NEXT FROM cMain_cursor
INTO @TT,@Year
END
CLOSE cMain_cursor
DEALLOCATE cMain_cursor

[linguojin11]

对数据库只有只读权限？

[sff_666]

靠 我查了查 游标不支持分组更新 。
高手有没有 什么好办法呀？
对于分组更新 ？