Oracle Form 10g
I really appreciate if someone help me out.
I am doing some complex validation via the key-commit trigger. It cannot be done using when-validate-item or when-validate-record trigger.
The problem is that if the user attempts to exit the form by clicking on the Windows 'x' or using any exit forms methods, he is prompted with the 'do you want to save changes' dialog. If he answers 'yes', all my validation is skipped.
I try to use put message on key -commit perform and I found that that trigger is not firing, I also tried to create on commit for and write do_key('commit_form') but getting lots of error message....
Any solutions?
In short, I want to forcefully execute my Key-Commit trigger....