This content has been marked as final. Show 10 replies
Hi 993293 ,
Welcome to the Oracle Forums. Please take a few minutes to review the following:
<li>Oracle Forums FAQ
<li>Before posting on this forum please read
<li>10 Commandments for the OTN Forums Member
<li>How to ask questions the smart way
Following these simple guidelines will ensure you have a positive experience in any forum; not just this one!
hello, i am using oracle 10g and i am stuck in the check boxes.So, you have database item say check_item and you want this item type as Check box and also send data 0 when checked and different value for unchecked.
i want to send value to data base 0 when check box is checked and different values when check box is unchecked. but i don't know how to do it in 10g forms.
can any one help plzzz....
Select your item at forms then go to properties (shortcut F4) and set the following property
You are done..
Item Type = Check Box Value When Checked =0 Value When Unchecked = different value Check box mapping of other values = checked/unchecked
Hope this helps
Mark correct/helpful to help others to get right answer(s).*
Thanks for your reply, i will keep your tips in mind and next time i will be care full about asking any question..
so will this code help me..
i am trying to create fee for student and in text field amount is coming from another table so i just want to do that when i don't want to send any text field record in database so on check it send value 0 to database and on unchecked it send amount that is in text field coming from another table .
so how i can do this??
my data base item is not check box item its a text field i just want to deal with text field on front end only..
Edited by: 993293 on Apr 12, 2013 12:53 AM
1. First u create a check box.
2. From poperty pallete, give value for Value When Checked- Y- and Value When Unchecked - N.
3. In the trigger that item, WHEN-CHECKBOX-CHANGED, write your code:
IF 'Y' = :control.cekbox then
:control.text := 0;
thnx for replay.
i tried but its not working it send value 100 to data base while the original value coming from fee_structure table into fee....
just tell me how to enable/disable text field using check box...
the last solution is correct if u do a little change as..
Hope it helps
IF 'Y' = :control.cekbox then select ___ ur db field name not it's value (100) is just an example into :control.text from fee_structure where... else :control.text := 0; end if;
IF 'Y' = :control.cekbox then set_item_property (v_item,ENABLED,PROPERTY_FALSE); else set_item_property (v_item,ENABLED,PROPERTY_TRUE); end if;
im new to oracle to please tell me what is :control is its a block name???
if it is then when i change it with block name its give "band-bind variable error".
is your code is like that...
IF 'Y' = :fee_stru .ad then
is this right???
':fee_stru (block name)', 'ad (check box name) ', 'admission_fee(text field name)'
thand for replay and plz tell me what is 'Y' in this and ':control'
:control is a control block ; non database block it is just an example in which it is supposeed that u put ur non database check box item in.
The error u got indicates u have no block with this name so u either put ur check in ur current database block or preferred create a non database block previously mentioned.
Y is just the value of ur current check box if checked u could use 0 or 1 / Y or N
if its value is a letter then use 'Y' coated with two single quote.
Hope it's clear
this is not working the code executed perfectly but its not enableling/disabling text field via check box so what should i do now im posting my code here you can check it..
where 'a' is check box name and fee_stru is and fee is table name and admission_fee is field name..
IF 'a' = :fee.a then
select fee_stru.admission_fee into :fee.admission_fee
where :fee.admission_fee = fee_stru.admission_fee;
:fee.a := 1 ;
Edited by: Moshialtaf on Apr 22, 2013 12:08 AM