Error creating cursor - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Development (2000)

Error creating cursor

Author

Topic

dsetzer
Starting Member

31 Posts

Posted - 2001-05-03 : 11:01:01

I am getting an error when I try creating this cursor:


declare cur_JJ cursor
for
	select od.orderDetailID, od.jobID
	from tblOrderDetails od
	where od.orderID = @orderID
	order by od.orderDetailID
	for update of od.jobID

The error I am getting is:
Server: Msg 16929, Level 16, State 4, Line 323
The cursor is READ ONLY.

Any ideas?

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources