OraFAQ Forum: Forms » form not showing 'transaction complete: n records saved'

Home » Developer & Programmer » Forms » form not showing 'transaction complete: n records saved' (forms 10g)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

form not showing 'transaction complete: n records saved' [message #411799]

Mon, 06 July 2009 18:43

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

Report message to a moderator

Re: form not showing 'transaction complete: n records saved' [message #411815 is a reply to message #411799]

Tue, 07 July 2009 00:08

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Is there :SYSTEM.MESSAGE_LEVEL set to certain (high?) value, somewhere in the code?

Report message to a moderator

Re: form not showing 'transaction complete: n records saved' [message #412049 is a reply to message #411815]

Tue, 07 July 2009 09:39

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?

Report message to a moderator

Re: form not showing 'transaction complete: n records saved' [message #412050 is a reply to message #411799]

Tue, 07 July 2009 09:42

cookiemonster
Messages: 13963
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.

Report message to a moderator

Re: form not showing 'transaction complete: n records saved' [message #412083 is a reply to message #412050]

Tue, 07 July 2009 12:47

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 ??

Report message to a moderator

Re: form not showing 'transaction complete: n records saved' [message #412099 is a reply to message #412083]

Tue, 07 July 2009 15:27

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Just search through all PL/SQL procedures. This is Forms 10g screenshot:

/forum/fa/6485/0/

Attachment: frm_find_plsql.PNG
(Size: 9.01KB, Downloaded 4373 times)

Report message to a moderator

Re: form not showing 'transaction complete: n records saved' [message #412416 is a reply to message #412099]

Thu, 09 July 2009 04:15

TonyJaa
Messages: 50
Registered: May 2009

Member

Is there any clear_message; in the code ?

Report message to a moderator

Re: form not showing 'transaction complete: n records saved' [message #413421 is a reply to message #412416]

Wed, 15 July 2009 11:24

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.

Report message to a moderator

Re: form not showing 'transaction complete: n records saved' [message #413448 is a reply to message #413421]

Wed, 15 July 2009 15:11

Littlefoot
Messages: 21823
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.

Report message to a moderator

Previous Topic:	Updating too many records
Next Topic:	Error : Using Combo Box .

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Feb 09 13:01:22 CST 2025