Save OLD VALUES to a separate history table in forms 6i

What I'm trying to accomplish is to write the OLD record values to a history table whenever the OLD record is changed.

I've attemped to do this with a SELECT * INTO hist_table WHERE (history table exact duplicate of production table) and want to do prior to the COMMIT_FORM (before NEW values are commited). I've tried placing in ON-COMMIT and PRE-UPDATE triggers, but with no success.

Do you have a suggestion on how to accomplish this and in what trigger. Thanks.
Sign In or Register to comment.

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!