Home » Developer & Programmer » Forms » how to reset all values in item without loop in oracle forms (Oracle Forms11G)
how to reset all values in item without loop in oracle forms [message #663778] Sun, 18 June 2017 10:33 Go to next message
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.
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 Go to previous message
Littlefoot
Messages: 21806
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.
Previous Topic: Oracle Forms 6i with Oracle DB 11g. Does it work?
Next Topic: Issue to import java class in forms 6i
Goto Forum:
  


Current Time: Fri Mar 29 01:31:49 CDT 2024