"Do you want to save the changes you have made?" with customized procedure [message #422765] |
Fri, 18 September 2009 18:30 |
secchan20
Messages: 31 Registered: April 2005
|
Member |
|
|
Hi,
How could I add my procedures (to set various flags) to "Do you want to save the changes you have made" message? Specifically when users select Yes on the message, I want to make sure they go through my procedures.
My procedures are coded in a commit button (when-button-pressed trigger) and key-commit trigger. Users are supposed to hit Commit button or F10 key to save changes, but they sometimes forget to press these keys and try to exit the form or enter another query after making changes and then hit Yes on the message. So some data didn't get correct flags because they skipped my procedures.
Any advice is appreciated.
Thanks.
|
|
|
|
|
Re: "Do you want to save the changes you have made?" with customized procedure [message #423015 is a reply to message #423006] |
Mon, 21 September 2009 17:38 |
secchan20
Messages: 31 Registered: April 2005
|
Member |
|
|
To go around the error, in stead of using on-commit, we are trying to use key-entqry to alert users "please commit first" so that they would go gack to the record they changed.
IF :system.form_status='CHANGED' THEN
alert_user(xxx);
return;
END IF;
Now I like to know how to alert users when they exit a form by clicking x on the top... Is there a built-in trigger? Any suggestion?
|
|
|
|
|
|
|