Home » Developer & Programmer » Forms » Saved Message
Saved Message [message #445520] Tue, 02 March 2010 05:50 Go to next message
ghadeer
Messages: 25
Registered: February 2010
Location: ksa
Junior Member
Hi All,
How can I remove (record asved) message that come automaticly
after commit??????

thanks
Re: Saved Message [message #445532 is a reply to message #445520] Tue, 02 March 2010 06:19 Go to previous messageGo to next message
cookiemonster
Messages: 12320
Registered: September 2008
Location: Rainy Manchester
Senior Member
read up on :system.message_level in form builder help.
Re: Saved Message [message #445693 is a reply to message #445532] Wed, 03 March 2010 06:46 Go to previous messageGo to next message
sts_sudha
Messages: 6
Registered: March 2010
Junior Member
Hi,

There are two ways to do that.

1. On-Message

Right a form level trigger "on-message" and say null. But i would prefer not to do this, because after this, it may not throw any message at all, which is very essential.

2. You can set the message level to 25. and re-set it to 0.

Please try with 2nd approach and let me know your opinion.

Regards
Sudhakar T
Re: Saved Message [message #445703 is a reply to message #445693] Wed, 03 March 2010 07:12 Go to previous messageGo to next message
Littlefoot
Messages: 20827
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
sts_sudha wrote on Wed, 03 March 2010 13:46
... and re-set it to 0.

Actually, you should reset it to its previous value (which doesn't have to be 0).
Re: Saved Message [message #445707 is a reply to message #445693] Wed, 03 March 2010 07:18 Go to previous messageGo to next message
cookiemonster
Messages: 12320
Registered: September 2008
Location: Rainy Manchester
Senior Member
sts_sudha wrote on Wed, 03 March 2010 12:46

1. On-Message

Right a form level trigger "on-message" and say null. But i would prefer not to do this, because after this, it may not throw any message at all, which is very essential.


May? Will!
Re: Saved Message [message #445728 is a reply to message #445520] Wed, 03 March 2010 10:46 Go to previous message
gregor
Messages: 86
Registered: March 2010
Location: Germany
Member
Hi,


The best way is: ín the trigger "on-message" trap
the right Error_code ( for xx) ( Error_code /Error_typ are Forms-built-ins)
Pseudo-Code :
For Example: ON-ERROR trigger at the FORM level
DECLARE

errcode NUMBER(5) := ERROR_CODE;
errtype VARCHAR2(3) := ERROR_TYPE;
errtext VARCHAR2(78) := ERROR_TEXT;
BEGIN
/* To suppress the message use NULL, to change the message use */
/* the MESSAGE built-in to display your own text.
 or better use "ALERT" built in  */
IF errcode = 40401 THEN
MESSAGE('Your own message text');
ELSIF errcode = 40405 THEN
NULL;
ELSE
/* Leave all other messages unchanged */
-- You can use ALERT-built if you like /need a Message-Box
MESSAGE( errtype | | '-' | | TO_CHAR(errcode) | | ': ' | |errtext );
END IF;
END;




CM: added code tags, please do so yourself next time - see the orafaq forum guide if you're not sure how.

[Updated on: Wed, 03 March 2010 10:49] by Moderator

Report message to a moderator

Previous Topic: popup menu in left click mouse
Next Topic: progress bar for uplouding files using webutil tech
Goto Forum:
  


Current Time: Thu Sep 29 02:12:14 CDT 2016

Total time taken to generate the page: 0.06211 seconds