Microsoft KB Archive/70846: Difference between revisions

Latest revision as of 19:29, 12 August 2020

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.

Revision as of 18:58, 18 July 2020 (view source) 3155ffGd (talk \| contribs) (importing KB archive)	Latest revision as of 19:29, 12 August 2020 (view source) X010 (talk \| contribs) m (X010 moved page Microsoft KB Archive/Q70846 to Microsoft KB Archive/70846 without leaving a redirect: Text replacement - "Microsoft KB Archive/Q" to "Microsoft KB Archive/")
(No difference)