Howdy, Stranger!

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

Categories

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

sturjinsturjin Member Posts: 1
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 id=:form.id (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.