This content has been marked as final. Show 4 replies
Create a Pre-Form trigger at form level and write down the following code
Hope this works..
:SYSTEM.MESSAGE_LEVEL := 5;
Rather than supress the message, I recommend you find where you are attempting to save (Commit_Form) when it is not needed. I see this over and over where developers just call COMMIT_FORM rather than check to see if there are changes to commit. Forms provides the following system variables that you can check to see if you need to issue a commit_form. They are, :SYSTEM.FORM_STATUS, :SYSTEM.BLOCK_STATUS and :SYSTEM.RECORD_STATUS. The values for these variables are: CHANGED, NEW and QUERY. Additionally, the RECORD_STATUS also has the INSERT value as well. To find out what these values mean, look up these system variables in the Forms Help system.
thanks for your reply,
here is the complete scenario,
I have a form "FORM1" from which, I am opening another form "FORM2". using the following code.
when I open the FORM2 and update a field and press exit button it alter " do you want to save changes" on pressing 'Yes" it 2nd time show alter "FRM-40405 no changes to apply".
OPEN_FORM('FORM2.FMX', ACTIVATE, NO_SESSION, LIST_ID);
I want to suppress this alert.
when using open_form with SESSION it don't give any alert.
here I am confused that the alert is coming from where? from FROM1 or FORM2?
I tried all the possible techniques to suppress this alert but couldn't be able to suppress.