Razzak, Thanks for the quick reply - I will try another approach.
Regards John Docherty -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of A. Razzak Memon Sent: Saturday, 28 May 2005 11:00 a.m. To: RBG7-L Mailing List Subject: [RBG7-L] - Re: Unable to update values in a view 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.
