View using UNION updatable?

• Jonathan Matt

  SSCarpal Tunnel

  Points: 4027

  More actions

  October 6, 2006 at 7:02 am

  #170540

  Hello all,

  Would you expect a view that uses UNION ALL to be updatable?

  The basics of the view are;

  SELECT whatever FROM whatever1

  UNION

  SELECT whatever FROM whatever2

  UNION

  .

  .

  .

  When I try to update whaterver2 through the view I get a message,

  "The view is no updatable because it contains derived or constant information." 

  JM

• Chris Chilvers

  SSCrazy

  Points: 2260

  More actions

  October 6, 2006 at 5:19 pm

  #664698

  You'll have to use an instead of update trigger to modify the underlying tables