Sharon,
Here is an example that drops the trigger, loads the procedure and creates an after insert trigger:
ALTER TABLE rfxrhr DROP TRIGGER INSERT
DROP PROCEDURE rfxrhr
PUT rfxrhr.prc AS rfxrhr RETURN INTEGER +
comment 'RF Release Roll from Hold Insert Trigger'
ALTER TABLE rfxrhr ADD triggers INSERT after rfxrhr
Hi All,
Great conference with lots of gems!
Unrelated to any of those topics, I am working on something most of you learned long ago.
I am trying to use Stored Procedures and Triggers for the first time. I successfully created the Stored Procedure and can run it using the CALL command.
Now, what I want to do is to Trigger the Procedure as an AFTER INSERT.
If I understand the documentation correctly, a Trigger runs the Procedure BEFORE the row is inserted, updated or deleted.
But, I thought I remembered hearing about AFTER INSERT Triggers at an RBTI Conference in the past.
Also, how do I put the Trigger in place?
What I am trying to do is to enter data for a new row into a form and then as the form is refreshed using an ADD Row button, I want to print a report based on the previously entered row.
Alternately, I would like to have a button on the form that would print data from the screen right to a report.
I don't know how to do this since the data has not been added to table yet.
Thanks for any help.
Sharon Lima
Manager, DairyPak Business Systems
Blue Ridge Paper Products, Inc.
40 Lindeman Drive
Trumbull, CT 06611
(203) 673-2231
[EMAIL PROTECTED]
[EMAIL PROTECTED]
