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.
