PRB: View Created with a Subquery Cannot Be Updated

ID: Q80398

The information in this article applies to:

Microsoft SQL Server for OS/2, version 4.2
Microsoft SQL Server version 4.2x

SYMPTOMS

A view created using a subquery cannot be updated. An attempt to update a view created with a subquery generates the following message:

View <view_name> is not updatable because it contains aggregates. (Msg 4403, Level 16, State 1).

CAUSE

This is similar to the case where a view created with an aggregate cannot be updated. This happens because the subqueries are processed as a special type of aggregate, and therefore few significant differences exist between aggregate and subquery processing.

According to ANSI (X3.135-1989), a view cannot be updated if it includes a subquery.

Additional query words: Windows NT


Keywords          : kbother SSrvTran_SQL SSrvWinNT 
Version           : 4.2 | 4.2
Platform          : OS/2 WINDOWS 
Issue type        :

Last Reviewed: March 12, 1999