Re: what's wrong with this trigger?

From: Yves RAISIN <rai_at_ofisa.ch>
Date: Fri, 21 Aug 1998 21:33:40 GMT
Message-ID: <35dde74c.57684522@firewall>

Just code it like this

BEGIN    IF UPDATING THEN

       IF  :old_customer_name <> :new_customer_name THEN
           :new.customer_name_idx := UPPER(:new.customer_name);
      END IF;

  END IF; On Wed, 19 Aug 1998 16:38:24 -0700, Troy Perchotte <max_at_headroom.com> wrote:

>I have a field that I would like to contain the upper case value of
>another field.
>
>If a user changes the value of my 'customer_name field', I would like to
>have the new value, in upper case, written to the 'customer_name_idx'
>field. (This is done because I use the customer_name_idx field for
>doing faster searches)
>
>A trigger something like the following (preferably one that actually
>works though):
>
>...
>begin
> if updating then
> update customers
> set customer_name_idx=upper(:new.customer_name);
> end if;
>end;
>
>Troy Perchotte
>
Received on Fri Aug 21 1998 - 16:33:40 CDT