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.