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 :-)
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.