OraFAQ Forum: Forms » How can i omit the message"No Change to save " in a forms

Home » Developer & Programmer » Forms » How can i omit the message"No Change to save " in a forms

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

How can i omit the message"No Change to save " in a forms [message #80347]

Thu, 12 September 2002 18:54

Susane
Messages: 27
Registered: September 2002

Junior Member

Hi,
I have a processing program running in forms i used a non database block used in the input processing.
I used a DML statements (INSERT, UPDATE, DELETE)
and issue a commit command. A message always appear 'No changes to save' how can i omit this message? We used Oracle Developer 2.1 form builders 5.0.6. Could anyone help me? Your reply is highly appreciated

Report message to a moderator

Re: How can i omit the message"No Change to save " in a forms [message #80365 is a reply to message #80347]

Fri, 13 September 2002 21:50

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;

Report message to a moderator

Previous Topic:	issuance of commit command in forms processing
Next Topic:	designer6i layout problems

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Feb 07 08:05:38 CST 2025