OraFAQ Forum: Forms » trigger gailure

Home » Developer & Programmer » Forms » trigger gailure

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

trigger gailure [message #224562]

Wed, 14 March 2007 12:14

rajat_chaudhary
Messages: 141
Registered: November 2006
Location: india

Senior Member

hi everyone ,
actually i made a form in which i introduced a text item in which a "when validate trigger" fires if recently data entered data existed then show an alert ,after pressing ok in alert it should go into the next item or after "cancel" item become null;
please give me reply i am waiting

Report message to a moderator

Re: trigger gailure [message #224599 is a reply to message #224562]

Wed, 14 March 2007 13:43

Frank
Messages: 7901
Registered: March 2000

Senior Member

rajat_chaudhary wrote on Wed, 14 March 2007 18:14

hi everyone
....
please give me reply i am waiting

eeh, hi?

I don't understand what it is you are asking for.
Please explain in simple words your current situation and your required situation.
And please use punctuation (commas, full stops, capitals etc.), it makes your post better readable and easier to understand.

Report message to a moderator

Re: trigger gailure [message #224839 is a reply to message #224599]

Thu, 15 March 2007 12:25

rajat_chaudhary
Messages: 141
Registered: November 2006
Location: india

Senior Member

FRANK its's for u.........
actually my question is that
i created a form application in which i introduced a "TEXT ITEM" in a block.

Now i want to applied a "VALIDATE TRIGGER" on that paricular text item.And the moment when it find any item already exist iin the database ,it shows an "ALERT"(ALERT MESSAGE ------ FOR CONTINUE PRESS OK AND FOR NOT PRESS CANCEL.") and when i pressing "OK BUTTON" it goes to "next item" else make that field "NULL". NOW THE I THOUGHT U GET IT.........

SO PLAESE REPLY ..............

Report message to a moderator

Re: trigger gailure [message #224853 is a reply to message #224839]

Thu, 15 March 2007 13:58

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Assume that
alert_button1 = OK
alert_button2 = Cancel

Now a little bit of untested code (I'm not in the mood at the moment, but - if you don't have anything better - try it):

DECLARE
   alert_btn NUMBER;
BEGIN
   ...
   IF alert_btn = alert_button2
   THEN
      CLEAR_ITEM;
   END IF;
END;

In another words: don't check <OK> because you'd go to the next item anyway. If the user presses <Cancel>, clear the current item.

NEXT_ITEM is a restricted procedure and can not be used in the WHEN-VALIDATE-ITEM trigger, so - forget about it. Navigation is to be done elsewhere.

Report message to a moderator

Previous Topic:	rename/ format column headings
Next Topic:	FRM-30087: Unable to create form file

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Feb 02 10:10:02 CST 2025