| Commit Statement [message #396104] |
Fri, 03 April 2009 23:55  |
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 #396108 is a reply to message #396107] |
Sat, 04 April 2009 00:18  |
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 |
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 |
|
|
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 |
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
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
