OraFAQ Forum: Forms » same alert box message display twice

Home » Developer & Programmer » Forms » same alert box message display twice

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

same alert box message display twice [message #151724]

Sun, 18 December 2005 13:28

meegoy
Messages: 2
Registered: October 2003

Junior Member

Ref: Oracle Form 4.5 running on AIX 4.3.2

Issue: How to avoid to have the exact same message show up twice?

I created a form with several items and two buttons INSERT button, DELETE button. Item2 is in date format (mm/dd/yyyy) with when_validiate_item trigger as follows:

   if item1 = a then
         if item2 < date1 then
    		message (‘message1’);
  	 	raise form_trigger_failure;
         end if;
  else
             if item2 < date2 then
    		message (‘message2’);
  	 	raise form_trigger_failure;
         end if;
   end if;

I also have a When-button-pressed trigger on INSERT button:
Commit;
Next_record;

If I enter a date < date1 to a new record, then press INSERT button, I get a message1 and an alert box with message1 at the same time. If I change message displayed in an alert box, it will display the same alert box twice.

[Updated on: Sun, 18 December 2005 23:29] by Moderator

Report message to a moderator