This discussion is archived
5 Replies Latest reply: Dec 29, 2012 1:46 PM by 982158 RSS

Problem with trigger WHEN-VALIDATE-ITEM

982158 Newbie
Currently Being Moderated
Hi all ..
i want to check my item to became unique in my database and the item exist in the database ,it must be clear(this item) !! ,so i use trigger when-validate-item for this item and trigger when-timer-expired for the form global ..
this is my code :
//trigger when-walidate-item :
          i number;
vTimer TIMER;
     begin



          IF //condition then
                    i := show_alert('ERROR');
                    /* Create a timer with a 10 Millisecond delay */
               vTimer :=create_timer('TEMP',10,no_repeat);

          end IF;


          end;

//trigger when-timer-expired
GO_BLOCK ('name_block');

:name_block.item1:=NULL;



DELETE_TIMER('TEMP');


But in runtime ,i was this error :
FRM-40202 Field must be entered !!

thnx :)

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points