Home » Developer & Programmer » Forms » How can i omit the message"No Change to save " in a forms
How can i omit the message"No Change to save " in a forms [message #80347] Thu, 12 September 2002 18:54 Go to next message
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
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 Go to previous message
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;
Previous Topic: issuance of commit command in forms processing
Next Topic: designer6i layout problems
Goto Forum:
  


Current Time: Thu Mar 28 03:24:41 CDT 2024