Re: SQL - Trigger

Rudy Fernandes wrote: > Tom wrote: > > > Hi, > > > > I have trigger on insert. Is this possible to change (by this trigger) 1 > > column in record which is inserted? > > Thanks for all answers > > create trigger tins_junk insert on junk referencing new as post> for each row > when (post.prd_cd is null) > (execute procedure junk_nulls(post.test_id, post.prd_cd) into prd_cd); I should have mentioned that the key to this capability is the use of the INTO statement in the trigger. Rudy