[RBG7-L] - Re: Unable to update values in a view

[A. Razzak Memon]

At 06:50 PM 5/27/2005, John Docherty wrote:

I am having difficulty understanding why I am unable to
update the values in a table when I using the EDI USING
command on a view created as follows:-

CREATE VIEW gdv AS SELECT +
  t1.pref, pord, grp +
  t2.VOL,VOLM,GREF,GNO,SPIGOT,GBOX,INS_NO,GALL,GSEQ, +
      made, ENTRY, gbd, gnote, gty +
  t3.size, de, supplier  +
 FROM systems t1, grilles t2, gd t3 +
 WHERE t1.pref= t2.pref and t2.gref=t3.gref

John,

FYI, you CANNOT update the view based on more than one table.

Very Best R:egards,

Razzak.