OraFAQ Forum: Forms » form trigger

Home » Developer & Programmer » Forms » form trigger

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

form trigger [message #144852]

Fri, 28 October 2005 10:46

seyiisq
Messages: 125
Registered: September 2005

Senior Member

I have the trigger shown below working in my database i need to get it to work in my form

create or replace trigger property_sta_trig
After insert or update on Property
For each row
DECLARE
BEGIN
Insert into property_status(property_status_id, property_id, Status, start_date, end_date)
values (property_sta_seq.nextval, :new.property_id,:new.status, :new.start_date, :new.end_date);
End property_sta_trig;
/

pls can you advice

[Updated on: Fri, 28 October 2005 11:01]

Report message to a moderator