Microsoft KB Archive/70846

PRSQL9103026: Error 4405 Occurs When Inserting Through Views 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.