BUG: Tablealias.Column in FOR UPDATE Causes Error 16928

ID: Q181358

The information in this article applies to:
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          : SSrvTran_SQL kbbug6.50 
Version           : WINNT:6.5
Platform          : winnt 
Issue type        : kbbug

Last Reviewed: April 21, 1999