Home » Developer & Programmer » Forms » form not showing 'transaction complete: n records saved' (forms 10g)
form not showing 'transaction complete: n records saved' [message #411799] Mon, 06 July 2009 18:43 Go to next message
nastyjillu
Messages: 211
Registered: February 2009
Senior Member
hi,
when i make any changes and hit Save button in the form i can see the below message

frm:40400 transaction complete : n records applied and saved'.

but iam not able to see the above message in other form. its saving to the database, but not displaying message.

i think its forms built in. but iam not suppressing that message, then why is it not displaying?

and how to display?

thanks
jillu
Re: form not showing 'transaction complete: n records saved' [message #411815 is a reply to message #411799] Tue, 07 July 2009 00:08 Go to previous messageGo to next message
Littlefoot
Messages: 20894
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Is there :SYSTEM.MESSAGE_LEVEL set to certain (high?) value, somewhere in the code?
Re: form not showing 'transaction complete: n records saved' [message #412049 is a reply to message #411815] Tue, 07 July 2009 09:39 Go to previous messageGo to next message
nastyjillu
Messages: 211
Registered: February 2009
Senior Member
No, there is no such code to suppress. if at all there is such code, it should be in the PLL. but the message is displayed in other forms. why not this form?
Re: form not showing 'transaction complete: n records saved' [message #412050 is a reply to message #411799] Tue, 07 July 2009 09:42 Go to previous messageGo to next message
cookiemonster
Messages: 12404
Registered: September 2008
Location: Rainy Manchester
Senior Member
Assuming your form really is saving data I guarantee there is some code somewhere that sets the message_level, you're just going to have to find it.
Re: form not showing 'transaction complete: n records saved' [message #412083 is a reply to message #412050] Tue, 07 July 2009 12:47 Go to previous messageGo to next message
nastyjillu
Messages: 211
Registered: February 2009
Senior Member
OK, I WILL find for system.message_level .

is there any specific trigger that you want me to find in ??
Re: form not showing 'transaction complete: n records saved' [message #412099 is a reply to message #412083] Tue, 07 July 2009 15:27 Go to previous messageGo to next message
Littlefoot
Messages: 20894
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Just search through all PL/SQL procedures. This is Forms 10g screenshot:

./fa/6485/0/
Re: form not showing 'transaction complete: n records saved' [message #412416 is a reply to message #412099] Thu, 09 July 2009 04:15 Go to previous messageGo to next message
TonyJaa
Messages: 50
Registered: May 2009
Member
Is there any clear_message; in the code ?
Re: form not showing 'transaction complete: n records saved' [message #413421 is a reply to message #412416] Wed, 15 July 2009 11:24 Go to previous messageGo to next message
nastyjillu
Messages: 211
Registered: February 2009
Senior Member
how to hide user defined message??

if i write commit_form;, it shows some user defined message that"cannot be saved".

i wrote clear_message; after commit_form;

even though its not suppressing that message.
Re: form not showing 'transaction complete: n records saved' [message #413448 is a reply to message #413421] Wed, 15 July 2009 15:11 Go to previous message
Littlefoot
Messages: 20894
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
So you want users to think that they have successfully saved changes, even though there was an error which prevented that to happen?

Anyway: check use of :SYSTEM.MESSAGE_LEVEL system variable.
Previous Topic: Updating too many records
Next Topic: Error : Using Combo Box .
Goto Forum:
  


Current Time: Mon Dec 05 08:51:29 CST 2016

Total time taken to generate the page: 0.05767 seconds