Home » Developer & Programmer » Forms » Commit Statement (Oracle 9i)
Commit Statement [message #396104] Fri, 03 April 2009 23:55 Go to next message
mvs_1952
Messages: 11
Registered: March 2008
Location: CHENNAI
Junior Member
Whenever 'Commit' statement is given in PL/SQL inside Forms6i, the system gives a message 'No Changes to Save'. Is there a way to suppress the message 'No Changes to Save' from appearing on the screen. I want to suppress this message optionally and not as a generalised parameterising.
Re: Commit Statement [message #396107 is a reply to message #396104] Sat, 04 April 2009 00:10 Go to previous messageGo to next message
danish_fsd@yahoo.com
Messages: 38
Registered: February 2008
Location: Pakistan
Member
Hi,

You can use ON-MESSAGE trigger at form level and suppress or write your custom message.

Regards

Danish
Re: Commit Statement [message #396108 is a reply to message #396107] Sat, 04 April 2009 00:18 Go to previous messageGo to next message
mvs_1952
Messages: 11
Registered: March 2008
Location: CHENNAI
Junior Member
Then it becomes a constraint at form level. What I was looking for is that if 'Commit' statement has to be given in 3,4 places in a form, I would like to suppress the 'No Changes to Save' in one of the places whereas I would prefer to have this message displayed at other places. Is it possible ?
Re: Commit Statement [message #396128 is a reply to message #396108] Sat, 04 April 2009 01:48 Go to previous messageGo to next message
danish_fsd@yahoo.com
Messages: 38
Registered: February 2008
Location: Pakistan
Member
First of all you choose a wrong forum. Your questions are form's related not of SQL/PLSQL.

However you may declare and set global variable at the time of commit (where you want) and can check this in ON-MESSAGE Trigger, it depends on your logic.

Hope it will help you.

Regards,

Danish.
Re: Commit Statement [message #396149 is a reply to message #396104] Sat, 04 April 2009 05:57 Go to previous messageGo to next message
itech
Messages: 168
Registered: May 2008
Location: Fsd, Pakistan
Senior Member

u can also set different values of system.message_level to suppress certain range of messages shown in status bar.

look for system.message_level in forms built in help for more details.
Re: Commit Statement [message #396194 is a reply to message #396149] Sat, 04 April 2009 18:34 Go to previous messageGo to next message
arunn
Messages: 52
Registered: September 2008
Location: usa
Member
Hi friend,

i think u can use the :System.Form_Status = 'CHANGED' .

if :System.Form_Status = 'CHANGED' then
commit.................

arun
Re: Commit Statement [message #396272 is a reply to message #396104] Sun, 05 April 2009 23:54 Go to previous message
mvs_1952
Messages: 11
Registered: March 2008
Location: CHENNAI
Junior Member
Thanks all. I have solved the issue.
Previous Topic: Need some help/Tips
Next Topic: how to fix the alignment (veritcal/horizontal) for cell using ole2
Goto Forum:
  


Current Time: Fri Dec 02 20:20:01 CST 2016

Total time taken to generate the page: 0.14047 seconds