from read only-cursor to updatable-cursor 1

[ruupy]

Hellow every~1,

Can anyone help me out with this cursorproblem i've got.
A standard local cursor, selecting a field per record into a declared variable will not allow an update (using 'WHERE CURRENT OF [cursorname]....

'Msg 16929 Level 16 CURSOR READ ONLY' is the result.


FOR UPDATE [tabel.columnname] does not change this errormessage.

What am i doing wrong here???

ThenX in advance.

RuupY

 

[tlbroadbent]

Check the topic "Implicit Cursor Conversions" in SQL BOL. It explains when cursors may be converted from requested cursor type to another. Terry

http://members.home.net/tlbroadbent/index.htm

 

[Cagliostro]

usualy it is a common problem for scroll cursors, and cursors wich contains group by, order by. John Fill

ivfmd@mail.md