Re: Trigger question..please help.
From: pereges <Broli00_at_gmail.com>
Date: Fri, 27 Mar 2009 18:59:52 -0700 (PDT)
Message-ID: <da715ec2-7239-45cc-be9f-eb7860ce6ab4_at_42g2000yqk.googlegroups.com>
On Mar 27, 9:34 pm, pereges <Brol..._at_gmail.com> wrote:
> On Mar 27, 8:43 pm, Shakespeare <what..._at_xs4all.nl> wrote:> By the dno column in employees I would think.... it may be a bit more
> > complex than I stated, but it can still be done this way. I just gave
> > some direction.
>
> Ok but how do I reference the tuple which has been updated from inside
> the trigger ?
Date: Fri, 27 Mar 2009 18:59:52 -0700 (PDT)
Message-ID: <da715ec2-7239-45cc-be9f-eb7860ce6ab4_at_42g2000yqk.googlegroups.com>
On Mar 27, 9:34 pm, pereges <Brol..._at_gmail.com> wrote:
> On Mar 27, 8:43 pm, Shakespeare <what..._at_xs4all.nl> wrote:> By the dno column in employees I would think.... it may be a bit more
> > complex than I stated, but it can still be done this way. I just gave
> > some direction.
>
> Ok but how do I reference the tuple which has been updated from inside
> the trigger ?
What I mean to say is that you cannot use OLD and NEW inside a statement level trigger. So how to access that data ? Received on Fri Mar 27 2009 - 20:59:52 CDT