Re: Help With Triggers

try to use an after insert trigger instead of a before insert trigger. I use the same in a db, and it works perfectly !

--
Kind regards,

Thomas Devallé
KSI Int'l
t.devalle_at_ksi.be
http://www.ksi.be

"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

>

>

>