OraFAQ Forum: Forms » Retrieve old value from List Item

Home » Developer & Programmer » Forms » Retrieve old value from List Item

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Retrieve old value from List Item [message #84524]

Fri, 26 March 2004 05:50

Antro
Messages: 10
Registered: March 2004

Junior Member

Hello Everyone,

I have a List item with values starting from 100 to 115. Whenever user changes a value I am capturing WHEN_LIST_CHANGED trigger.

I would like to know how can I get the OLD value of the list item. I can get the new value just with the field name, but dont know what was the previous value in the list item. Is there a way to find it?

Thanks,

Antro

�

�

Report message to a moderator

Re: Retrieve old value from List Item [message #84532 is a reply to message #84524]

Sat, 27 March 2004 09:18

new learner
Messages: 2
Registered: March 2004

Junior Member

Capture the initial value of the list item - the default value into old_value.

In when list changed, copy new_value to old_value2.

Process with new_value and old_value.

After you finish processing the logic, copy old_value2 to old_value.

Your old_value2 is a temporary space you are using before processing.

hope this helps

Report message to a moderator

Re: Retrieve old value from List Item [message #84550 is a reply to message #84524]

Mon, 29 March 2004 10:11

jan
Messages: 71
Registered: August 2002

Member

you can create a dummy item lets say l_old_val
and then create a when-new-item-instance trigger on this list item and set the current value to the l_ild_val and in your when-list-changed trigger you can always refer to this value.
e.g.
lets say you have a lits item called my_list_item
create a text item called my_text_item
create a when-new-item-instance trigger on my_list_item
with code as my_text_item := my_list_item;

and create another trigger when-list-changed on my_list_item

here you can always find the value of old list item as :my_text_item.

hope this helps.

Jan

Report message to a moderator