| issuance of commit command in forms processing [message #80346] |
Thu, 12 September 2002 18:31  |
Susane
Messages: 27
Registered: September 2002
|
Junior Member |
|
|
|
im using oracle developer 2000 form builder release 2.1, i have a processing program that used DML, everytime program executed the commit command it always display message, i wanted to remove this message, anyone here can help?
|
|
|
|
|
|
| Re: issuance of commit command in forms processing [message #80351 is a reply to message #80346] |
Fri, 13 September 2002 00:24  |
sane
Messages: 3
Registered: September 2002
|
Junior Member |
|
|
neeraj,
thank you very much for your response
but it doesnt work. i used also on-message trigger
but nothing happen still the message appear. and
have to answer ok to continue the processing.
can u have any suggestion. your response is highly appreciated.
sane
|
|
|
|
| Re: issuance of commit command in forms processing [message #80358 is a reply to message #80346] |
Fri, 13 September 2002 07:16 |
Sameer
Messages: 60
Registered: March 1998
|
Member |
|
|
|
DO one thing in On-message trigger u customize the msg with ur msg.Like the code for saving is something frm-4010....something like that so in the if condition of ur On-message trigger u put ur msg to display.Or if u do not want to show anything simply say null in this trigger.
|
|
|
|
| Re: issuance of commit command in forms processing [message #80364 is a reply to message #80346] |
Fri, 13 September 2002 21:45 |
Sameer
Messages: 60
Registered: March 1998
|
Member |
|
|
In on-message trigger
DECLARE
msgnum NUMBER := MESSAGE_CODE;
msgtxt VARCHAR2(80) := MESSAGE_TEXT;
msgtyp VARCHAR2(3) := MESSAGE_TYPE;
BEGIN
IF msgnum in (40400) THEN
Message('Changes Applied & Saved');
MESSAGE(' ');
--if u do not want any message then
--null;
-- ELSIF msgnum = 40401 THEN
-- Message('You have no unsaved changes outstanding.');
END IF;
END;
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
