This discussion is archived
3 Replies Latest reply: Sep 24, 2013 6:40 AM by CraigB RSS


shabbir Newbie
Currently Being Moderated

Hi everybody,


is there any way or a similar criteria in oracle forms to use ":new" and ":old" operators like we use in database triggers ? these operators can not be used in oracle forms for sure, i need a similar criteria to find ":old.amount - :new.amount" thing at when validate item trigger, without saving the record at runtime !!!


thanking in advance :-)



  • 1. Re: old_new_operators_in_forms
    Pervez-EBL Newbie
    Currently Being Moderated

    Yes, u can use old and new qualifier only for database row trigger only.

  • 2. Re: old_new_operators_in_forms
    Soofi Explorer
    Currently Being Moderated

    Hi Shabbir,

    As far as i know there is no way to use : old and : new in forms....


    Rather you can do something like this



    Take a cursor of the table matching the last saved record







    This will do what you want...




  • 3. Re: old_new_operators_in_forms
    CraigB Guru
    Currently Being Moderated

    I think the closest thing you will find to the :OLD/:NEW operators in Forms is the Get_Item_Property('ITEM_NAME',DATABASE_VALUE) built-in.  You can compare the value returned by this built-in to the current value of the item to see if the value has changed since it was originally queried into the form.  This will only work, however, if Forms queried the value.  If you manually fetch and display a value, then this built-in will return NULL. 



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