各位大哥，我有一个关于cursor的问题，想要请教，谢谢了，在线等待

[salt3000]

我的cursor的声明语句如下：
declare ht_curs cursor for select changjiafeiyong,changjiazhekou,jisuanleixing,zhi,shuliangs,danjia,danjia_kd from #t1 order by hetongbianhao,bianhao for update

可是为什么系统报错说：The cursor is READ ONLY
报错行数是指向declare cursor 那句话的
为什么啊！！！我写了for update 的呀

[CrazyFor]

declare ht_curs cursor for select changjiafeiyong,changjiazhekou,jisuanleixing,zhi,shuliangs,danjia,danjia_kd from #t1 order by hetongbianhao,bianhao for update 字段1,字段2,字段3....

把要更新的字段跟在后面,如上.

[CrazyFor]

declare ht_curs cursor for select changjiafeiyong,changjiazhekou,jisuanleixing,zhi,shuliangs,danjia,danjia_kd from #t1 order by hetongbianhao,bianhao for update 字段1,字段2,字段3....

把要更新的字段跟在后面,如上.

[txlicenhe]

最好有全部代码。

try:
declare ht_curs cursor for select changjiafeiyong,changjiazhekou,jisuanleixing,zhi,shuliangs,danjia,danjia_kd from #t1 order by hetongbianhao,bianhao for update of changjiafeiyong

[txlicenhe]

-- =============================================
-- Declare and using an UPDATE cursor
-- =============================================
DECLARE <@variable_1, sysname, @v1> <datatype_for_variable_1, sysname, varchar(20)>,
<@variable_2, sysname, @v2> <datatype_for_variable_2, sysname, varchar(40)>

DECLARE <cursor_name, sysname, test_cursor> CURSOR
FOR SELECT <column_1, sysname, au_fname>, <column_2, sysname, au_lname> FROM <table_name, sysname, pubs.dbo.authors>
FOR UPDATE of <column_1, sysname, au_fname>

DECLARE @count smallint
SELECT @count = 1

OPEN <cursor_name, sysname, test_cursor>
FETCH NEXT FROM <cursor_name, sysname, test_cursor> INTO <@variable_1, sysname, @v1>, <@variable_2, sysname, @v2>

WHILE (@@fetch_status <> -1)
BEGIN
IF (@@fetch_status <> -2)
BEGIN
-- PRINT 'add user-defined code here...'
-- eg
PRINT 'updating record of ' + @v1 + ' ' + @v2
UPDATE pubs.dbo.authors
SET au_fname = @v1 + '-' + CAST(@count AS varchar(4))
WHERE au_lname = @v2
END
FETCH NEXT FROM <cursor_name, sysname, test_cursor> INTO <@variable_1, sysname, @v1>, <@variable_2, sysname, @v2>
SELECT @count = @count + 1
END

CLOSE <cursor_name, sysname, test_cursor>
DEALLOCATE <cursor_name, sysname, test_cursor>
GO

[zjcxc]

问题应该出在order by 上,有order by 的情况是不支持更新的.

你试试
declare ht_curs cursor for select changjiafeiyong,changjiazhekou,jisuanleixing,zhi,shuliangs,danjia,danjia_kd from #t1 for update

[hjb111]

declare ht_curs cursor for select changjiafeiyong,changjiazhekou,jisuanleixing,zhi,shuliangs,danjia,danjia_kd from #t1 order by hetongbianhao,bianhao for read only

[salt3000]

order by 对，就是order by 的问题，谢谢，老大，谢谢

[salt3000]

结贴喽