Kremena Hagen
New Member
Hello Everybody,
First of all I have to admit that I am not a Progress DBA but I was assigned to do some updates on our db schema.
We are running MFG/PRO and I am interested in creating a schema trigger. Basically, I want to create a record in a separate table for every new sales order added to the so_mstr table. I'm thinking that a "REPLICATION-CREATE" trigger is needed for the so_mstr table. I have never created a REPLICATION-CREATE trigger before.
If any of you have done something similar would you please post a sample of how to create a trigger that will update an external table for every newly created record on an existing table (so_mstr)?
I appreciate your help.
Kremena
First of all I have to admit that I am not a Progress DBA but I was assigned to do some updates on our db schema.
We are running MFG/PRO and I am interested in creating a schema trigger. Basically, I want to create a record in a separate table for every new sales order added to the so_mstr table. I'm thinking that a "REPLICATION-CREATE" trigger is needed for the so_mstr table. I have never created a REPLICATION-CREATE trigger before.
If any of you have done something similar would you please post a sample of how to create a trigger that will update an external table for every newly created record on an existing table (so_mstr)?
I appreciate your help.
Kremena