| Item, old value [message #252580] |
Thu, 19 July 2007 04:24  |
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  |
 |
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS 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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
