Microsoft KB Archive/183149

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

Article ID: 183149

Article Last Modified on 10/3/2003

-

APPLIES TO


 * Microsoft SQL Server 6.5 Standard Edition

-



This article was previously published under Q183149



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: kbbug kbpending KB183149

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.