ID Number: Q70846
1.10
OS/2
buglist1.10
Summary:
PROBLEM ID: PRSQL9103026
SYMPTOMS
The following error is displayed when trying to update through a
view:
View 'viewname' is not updatable because the FROM clause names
multiple tables.
(Msg 4405 Level 16, State 1)
CAUSE
This error message is displayed if the view definition contains
more than one table. It should only be displayed if the INSERT
statement references more than one table, since INSERT and UPDATE
statements are not allowed unless the columns being updated all
belong to the same base table.
RESOLUTION
Update the table directly.