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.