Re: New to Triggers - Help Please -

From: Mike M. <okana_at_msn.com>
Date: Mon, 30 Aug 1999 06:53:56 -0700
Message-ID: <wDyy3.2904$9e4.22544611_at_IRIS>


[Quoted] Thanks to everyone who offered assistance - I don't know why but the trigger [Quoted] just would not work - I even had a second pair of eyes look at it, check the [Quoted] syntax and everything. I just handled it in code instead.

Mike

Mike M. <okana_at_msn.com> wrote in message news:G9Bx3.1487$Kuf.6225975_at_IRIS...
> I am just starting to write my own triggers and I have a big project ahead
> of me that may involve several of them - I already have several that
> evaluate and assign values upon inserts - those were a piece of cake - but
> now I'm dealing with data validation.
>
> Here is the first one - and I'm not sure where the error is, actually I'm
> not even sure I'm doing it right.
>
> I was using the GUI to try and design it, but a SQL statement will work
fine
> if I someone wants to assist me -
>
> Oracle 8.05 on NT4
>
> Table: Customers
> Column: OUTCOME
>
> Before update on row: if old.outcome = 14500 and new.outcome in (11000,
> 12000, 11001) then new.outcome = 14500
>
> In other words, if the new outcome code is 11000, 12000 or 11001 then
don't
> change it. And I don't need an error raised to the user.
>
> Some assistance would be greatly appreciated -
>
> Mike
> mikem_at_msamail.com
> okana_at_msn.com
>
>
>
>
>
>
Received on Mon Aug 30 1999 - 15:53:56 CEST

Original text of this message