Forms - How to record errors

[BJCooperIT]

OK folks, here is my dilemma. I have a client who wants forms to keep track of error messages displayed by forms. My problem is that fatal errors in the form will prevent database commits.

For example, a form has a foreign key field in which the user enters an invalid value. In the WHEN-VALIDATE-ITEM trigger, the value is found to be invalid. An insert statement into an error audit table is added before the "raise form_trigger_failure". Won't the inserted row rollback if the user cannot commit?

Any ideas?

 

[sem]

You may write to file system log or send error messages via pipe (asuming that some program (job) is reading this pipe and writing the message to the table).