Re: Help With Triggers

Hi!

Could you supply error message(s)? if any.

By a quick look, I think it seems that you are adding a trigger to a system table.
Is that really a clean way?
I hope you have considered many(all:-) other options before doing that.

Frank!

Jefferson Gallaway <jkgallaway_at_home.com> wrote in message news:jEFm6.6297$Ye3.1402882_at_news1.rdc1.az.home.com...
> Please help:
>
> While this trigger is created without error in the SCHEMA Manager,
> my application refuses to validate the code.
> I am trying to take just a few of the values being inserted into table1
 and
> insert those into table2
>
> CREATE or replace TRIGGER system.event_insert_trig
> BEFORE insert ON system.event
> REFERENCES NEW as new
> FOR each row
> BEGIN
> INSERT INTO system.CATALOG_EVENT
> VALUES ( :new.event_id, :new.campaign_id, :new.event_name,
> :new.event_desc, :new.concept_id, :new.channel_id,
> :new.company_id, 'N' );
> END;
>
>
> Jefferson Gallaway
> jkgallawy_at_home.com
>
>
>
Received on Wed Feb 28 2001 - 18:05:32 CET