Home » Developer & Programmer » Forms » how to supress system messages
how to supress system messages [message #82190] Mon, 05 May 2003 02:18 Go to next message
Messages: 19
Registered: March 2002
Junior Member

i have commit in my forms. so when i run the forms, it is telling FRM-40401 NO CHANGES TO SAVE. I HAVE TO ELIMINATE THIS MESSAGE.Can anybody help me.

Thanks in advance
Re: how to supress system messages [message #82192 is a reply to message #82190] Mon, 05 May 2003 02:57 Go to previous messageGo to next message
Cindreen Rameshwaran
Messages: 4
Registered: May 2003
Junior Member
put this code in the On-Error trigger at form level

if error_code <> 40401 then
message (error_type || '-' || to_char(error_code) || ':' || error_text);
end if;
Re: how to supress system messages [message #82193 is a reply to message #82190] Mon, 05 May 2003 03:59 Go to previous message
Messages: 7064
Registered: December 2001
Senior Member
From Forms Help:

When you build multiple-form applications, you might want to suppress messages regarding transaction posting and committing. To do so, set the SYSTEM.MESSAGE_LEVEL system variable to 5 just before a post or commit, then reset it to the desired value.
This clearly states the way to do what you want (suppressing information messages).
To make the messages of lowest severity disappear, put this in the WHEN-NEW-FORM-INSTANCE: :SYSTEM.Message_level:=5;

Previous Topic: plzz help
Next Topic: Problem with A. Server 9i/forms6i installtion
Goto Forum:

Current Time: Sun Jul 03 10:39:51 CDT 2022