OraFAQ Forum: Forms » how to reset all values in item without loop in oracle forms

Home » Developer & Programmer » Forms » how to reset all values in item without loop in oracle forms (Oracle Forms11G)

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

how to reset all values in item without loop in oracle forms [message #663778]

Sun, 18 June 2017 10:33

victoryhendry
Messages: 96
Registered: January 2007
Location: Bangalore

Member

how to reset all values in item without loop in oracle forms.

my requirement is when check_box_changed trigger raise in item1, it has to reset all the values in item2.

example :
:block1.item1
when check_box_changed trigger then

if :block1.item1 := 'Y' then

:block1.item2 := 'N' ; --its resetting only current value but I want to reset all the values to N in item2.

end if;

Thanks for your support.

Report message to a moderator

Re: how to reset all values in item without loop in oracle forms [message #663779 is a reply to message #663778]

Sun, 18 June 2017 12:18

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

Senior Member
Account Moderator

If CLEAR_BLOCK or CLEAR_FORM can be used - use them. Or, you could UPDATE table column values and re-query the block. Otherwise, I think that loop is the only other way to do that.

Report message to a moderator

Previous Topic:	Oracle Forms 6i with Oracle DB 11g. Does it work?
Next Topic:	Issue to import java class in forms 6i

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Mar 03 09:59:26 CST 2026