OraFAQ Forum: Forms » how to check a particual item is updated in a block

Home » Developer & Programmer » Forms » how to check a particual item is updated in a block (forms 6i)

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

how to check a particual item is updated in a block [message #445415]

Mon, 01 March 2010 11:47

mohaninforakle
Messages: 55
Registered: January 2009

Member

hi,

I have a form in which i had 6 items in a block,like sno,task,responsible,totaldays,date,status .Except 'totaldays' item all items will be updated when i press button called 'Update'.am doing this in on - update by using if(:system.block_status='changed').

Now i want only if a specific item 'totaldays' is changed , the on-update should happen.

i have 6 items in a block
sno
task
responsible,
totaldays
date,
status

only if i change totaldays item the on - update should happen

how to do this?
Please somebody help me on this.
am waiting for your reply thanks in advance

Report message to a moderator

Re: how to check a particual item is updated in a block [message #445417 is a reply to message #445415]

Mon, 01 March 2010 11:55

Littlefoot
Messages: 21818
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Perhaps you could use the PRE-RECORD trigger to store current value of the "todaldays" item (into a parameter or a global variable) and check it when the "update" button is pressed. Something like this:

-- PRE-RECORD
:parameter.totaldays := :block_name.totaldays;

-- WHEN-BUTTON-PRESSED
if :block_name.totaldays <> :parameter.totaldays then
   <update>
else
   message('Totaldays did not change');
   null;
end if;

Report message to a moderator

Re: how to check a particual item is updated in a block [message #445422 is a reply to message #445415]

Mon, 01 March 2010 13:35

cookiemonster
Messages: 13938
Registered: September 2008
Location: Rainy Manchester

Senior Member

You can proably also use:

get_item_property(<item_name>, database_value);

Report message to a moderator

Re: how to check a particual item is updated in a block [message #445545 is a reply to message #445415]

Tue, 02 March 2010 07:31

mohaninforakle
Messages: 55
Registered: January 2009

Member

Thanks for your reply i hope this will work i wiil try this and let you know

Thank you once again

Report message to a moderator

Previous Topic:	Issues during migration from forms 4.5 to 10g
Next Topic:	i am logged in as other person in forms application & how URL is assigned to different users whe

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 10:47:15 CDT 2024