BUG: Error 16928 Encountered When Using 'For Update of' Cursor

ID: Q183149

The information in this article applies to:

• Microsoft SQL Server, version 6.5

SYMPTOMS

Error 16928 may occur on the client when executing a stored procedure in which:

• A temporary table is created.

  -and-

• A 'for update' cursor with a column list is declared on this temporary table.

WORKAROUND

To work around this problem, instead of using the 'for update' cursor with a column list, put the desired column in the select list and declare the cursor as updateable.

STATUS

Microsoft has confirmed this to be a problem in SQL Server version 6.5. We are researching this problem and will post new information here in the Microsoft Knowledge Base as it becomes available.

Additional query words: updatable

Keywords          : SSrvStProc SSrvTran_SQL 
Version           : WINNT:6.5
Platform          : winnt
Issue type        : kbbug
Solution Type     : kbpending

Last Reviewed: March 28, 1998