Thanks Razzak, sorry I needed to read your first reply more closely. (I thought from the Help description that you could do this with a multi table view - "In multi-table views you can edit data but you cannot add or delete rows..")
Regards John Docherty -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of A. Razzak Memon Sent: Saturday, 28 May 2005 11:49 a.m. To: RBG7-L Mailing List Subject: [RBG7-L] - Re: Unable to update values in a view At 07:39 PM 5/27/2005, John Docherty wrote: >Razzak, > >I have created another view, with only two tables, as follows, but I still >cannot edit this with either a form or an EDIT ALL IN gdc WHERE.. command. > >CREATE VIEW gdc AS SELECT + > t1.pref, pord, grp + > t2.VOL,VOLM,GREF,GNO,SPIGOT,GBOX,INS_NO,GALL,GSEQ, + > made, ENTRY, gbd, gnote, gty + > FROM systems t1, grilles t2 + > WHERE t1.pref= t2.pref > >Can you please give me a few more pointers on this. John, FYI, you CANNOT update the view based on more than one table. Very Best R:egards, Razzak. >-----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.
