Home » Developer & Programmer » Forms » Item, old value
Item, old value [message #252580] Thu, 19 July 2007 04:24 Go to next message
dimis283
Messages: 38
Registered: July 2007
Location: greece
Member
I have a form and a block at it.
I want to take the value of a Item of this block before the update and compare it with the new value after the update.
I know generally that we use the ":old and :new" for the values but how can we do it at Oracle forms and at what trigger?
Thank You
Dimis

[Updated on: Thu, 19 July 2007 08:14]

Report message to a moderator

Re: Item, old value [message #253176 is a reply to message #252580] Mon, 23 July 2007 01:08 Go to previous message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Two choices:

In the Post-Query trigger make a copy of your incoming data into a set of non-database fields. Eg table has a column 'NAME', you create in the block an item 'NAME_NBT' then in the Post-Query trigger you have an assignment ':blk.name_nbt := :blk.name;'. You can then run the 'IF' test between these two fields.

Alternatively, use the 'get_item_property(:blk.name,database_value)' in the 'IF' test.

David
Previous Topic: how i can assign multiple values to tabuler text item
Next Topic: using # in query where dialog box in forms9i
Goto Forum:
  


Current Time: Fri Dec 09 00:15:17 CST 2016

Total time taken to generate the page: 0.16516 seconds