Microsoft KB Archive/69201

PRSQL9012037: Error 4405 When Inserting Through Views ID Number: Q69201

1.10 OS/2 buglist1.10

Summary:

PROBLEM ID: PRSQL9012037

SYMPTOMS When executing the following insert statement to insert a row into one base table through a view

insert test_view (t1col1, t1col2) values (31,37) the following error message is returned:

View 'test_view' is not updatable because the FROM clause names multiple tables. (Msg 4405, Level 16, State 1) RESOLUTION Insert the rows directly to the base tables, rather than through the view.

Microsoft has confirmed this to be a problem in SQL Server version 1.1. We are researching this problem and will post new information here as it becomes available.