Re: what's wrong with this trigger?

More information need.
For which table this trigger performs ? customers ? What error this trigger causes ?
Is table customers dependend of your trigger table ?

Maxim.

Troy Perchotte 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 Sat Aug 22 1998 - 07:34:34 CDT