Microsoft KB Archive/181358

= BUG: Tablealias.Column in FOR UPDATE Causes Error 16928 =

Article ID: 181358

Article Last Modified on 10/3/2003

-

APPLIES TO


 * Microsoft SQL Server 6.5 Standard Edition

-



This article was previously published under Q181358



BUG #: 17803 (6.5)



SYMPTOMS
If you precede a column name with the table alias in the FOR UPDATE clause of a cursor, cursor declaration will fail with the following error:

Msg 16928, Level 16, State 3

The column name 'au_lname' specified in the FOR UPDATE list is invalid

or ambiguous.

The following example statements will demonstrate the problem:

declare t1_cursor cursor for select au_id, au_lname from authors a1  for update of a1.au_lname



WORKAROUND
To work around this problem, either remove the alias or prefix the column name with the table name.



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.

Keywords: kbbug KB181358

-

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

© Microsoft Corporation. All rights reserved.