Key Commit not firing when user exists form
sharpeAug 31 2010 — edited Aug 31 2010I have a form where a user makes a change to a record and then attempts to exit the form without saving. Oracle Forms prompts "Record has been changed. Do you want to continue without saving?" And the user can select "Yes" or "Cancel". In my case the user is clicking "Yes". Then Oracle Forms prompts "Do you want to save the changes you have made?". And the user is inadvertanly clicking "Yes" instead of "No".
The problem is that when the user selects "Yes" the data is saved, but my Key Commit trigger does not fire and bad or incomplete data is being saved on the form.
How can I get my Key Commit Trigger code to fire in this situation? Or how can I avoid the user being given these prompts by Oracle Forms???
Any help would be greatly appreciated.