OraFAQ Forum: Forms » CheckBox controls column values

Home » Developer & Programmer » Forms » CheckBox controls column values (Forms Builder 6i)

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

CheckBox controls column values [message #562598]

Thu, 02 August 2012 12:48

vaibhav15211
Messages: 38
Registered: August 2012
Location: Hyderabad

Member

I am totally new to forms and don't have any idea how to solve this problem, please help.
I have a custom form build on Oracle Forms Builder 6i. It is divided into tow tabs
I have to place a checkbox on tab 1 and control the values of a column present on tab2. When the checkbox is ticked the values in column should be 'X'
and if the checkbox in unchecked all the values should be changed to 'Y'.

Please suggest how to achieve this.

Thanks vaibhav

[Updated on: Thu, 02 August 2012 12:51]

Report message to a moderator

Re: CheckBox controls column values [message #562599 is a reply to message #562598]

Thu, 02 August 2012 12:52

joy_division
Messages: 4963
Registered: February 2005
Location: East Coast USA

Senior Member

if :checkbox = 'X' then
   :col1 := 'X';
   :col2 := 'X';
   etc.
else
   :col1 := 'Y';
   :col2 := 'Y';
   etc.
end if;

Report message to a moderator

Re: CheckBox controls column values [message #562831 is a reply to message #562599]

Mon, 06 August 2012 04:20

vaibhav15211
Messages: 38
Registered: August 2012
Location: Hyderabad

Member

Hello Joy,

Thanks for the prompt reply. I tried the above but it is not working due to my lack of knowledge.
I tried to write it in WHEN-CHECKBOX-CHANGED trigger but it didn't worked.
Please suggest:
1. How would I know when the checkbox is checked? something like ..IF checkbox_checked()THEN {....}
2. How can I relate the checkbox to a particular column?

Thanks
Vaibhav

Report message to a moderator

Re: CheckBox controls column values [message #562869 is a reply to message #562831]

Mon, 06 August 2012 07:37

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

Senior Member

1) Check the actual checkbox value, like in Joys code above. The property pallete for the checkbox will say what values are checked and unchecked.
2) The column the checkbox is related to is determined by the property pallete - the column name property, or a column of the same name as the item if it's blank. If you want the checkbox to affect other columns then you need to code that manually like Joys example.

Report message to a moderator

Previous Topic:	Oracle Forms check Box / submit button
Next Topic:	Forms F11 Compound statements

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Jul 04 15:47:10 CDT 2024