Home » Developer & Programmer » Forms » Save confirmation (Form,6i,XP)
Save confirmation [message #336195] Fri, 25 July 2008 02:45 Go to next message
gozuhair
Messages: 206
Registered: January 2008
Senior Member
Dear All

How can i show following types of oracle default messages by using as a alert .


Transaction complete 1 record applied and saved 



same as



oracle error unable to insert record

Re: Save confirmation [message #336517 is a reply to message #336195] Mon, 28 July 2008 00:03 Go to previous messageGo to next message
gurupatham
Messages: 66
Registered: March 2008
Location: Chennai
Member
There are many ways to suppress this type of message
Can suppress by using ON-Message Trigger in form level
or :system.Message_level
Re: Save confirmation [message #336526 is a reply to message #336517] Mon, 28 July 2008 00:55 Go to previous messageGo to next message
gozuhair
Messages: 206
Registered: January 2008
Senior Member
Thanks for the reply, but how could i know the system level no of "save".
Re: Save confirmation [message #336539 is a reply to message #336526] Mon, 28 July 2008 01:31 Go to previous messageGo to next message
gurupatham
Messages: 66
Registered: March 2008
Location: Chennai
Member
Use the sample code to suppress the error message whose level is less than or equal to 25.

declare
	nOldMessageLevel Number;
Begin
	nOldMessageLevel := :system.Message_level;
	:system.Message_level := 25;
	commit_form;
	:system.Message_level := nOldMessagelevel;
end ;

	
Re: Save confirmation [message #336573 is a reply to message #336539] Mon, 28 July 2008 03:39 Go to previous messageGo to next message
gozuhair
Messages: 206
Registered: January 2008
Senior Member
Thanks for the codes, but its not working in my case .My problem is that i just want to catch and show oracle default message

Transaction complete 1 record applied and saved 



as an alert message but due to some technical reason ,the message is not shown in my form.i am going to attached my form for your reference.
  • Attachment: sp_prt.fmb
    (Size: 352.00KB, Downloaded 141 times)
Re: Save confirmation [message #336596 is a reply to message #336573] Mon, 28 July 2008 05:52 Go to previous messageGo to next message
gurupatham
Messages: 66
Registered: March 2008
Location: Chennai
Member
Commend the following code in Init procedure then try to bring in Alert window.
Use Message_text instead of ERROR_TEXT in ON-Error Trigger.

:SYSTEM.MESSAGE_LEVEL := '25';
:SYSTEM.MESSAGE_LEVEL := '0';



Re: Save confirmation [message #336607 is a reply to message #336596] Mon, 28 July 2008 06:29 Go to previous messageGo to next message
gozuhair
Messages: 206
Registered: January 2008
Senior Member
I want to show message at the time of success saving not at the time of forms open becase init procedure activates "when new form instance" events
Re: Save confirmation [message #336616 is a reply to message #336195] Mon, 28 July 2008 06:55 Go to previous messageGo to next message
gurupatham
Messages: 66
Registered: March 2008
Location: Chennai
Member
in When-New-Form-Instance , You set message level to 25 and reset it in Exception part. if there is no exception , Message level will always be 25 . So it suppresses all message level at 25 and below.
Re: Save confirmation [message #336720 is a reply to message #336616] Mon, 28 July 2008 15:32 Go to previous messageGo to next message
Littlefoot
Messages: 20901
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Which is, of course, quite a bad idea (as you might find yourself dazzled with a non-working form and (later) report such a behaviour back here saying that "there's nothing there, but form doesn't work)).
Re: Save confirmation [message #336760 is a reply to message #336720] Mon, 28 July 2008 22:27 Go to previous message
gozuhair
Messages: 206
Registered: January 2008
Senior Member
ok ,will try it and then let you know the exact position
Previous Topic: Current_Row_White_On_Black
Next Topic: List of values
Goto Forum:
  


Current Time: Fri Dec 09 15:17:25 CST 2016

Total time taken to generate the page: 0.42977 seconds