Skip to Main Content

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Triggers in checkbox apex

User_TQNO8Feb 24 2011 — edited Feb 24 2011
Hello all,

I'm having a problem that i believe is a basic apex question and I need some help with it:

I have a table where I have a column "acceptance". I need to create a report or a tubular form with to check boxes to manipulate this column "acceptance" :
"Accepted" check box and
"Rejected" Check box.

In this grid the user will be allowed to accept or reject the row clicking in one of the check boxes. Wen the user click in one of them I need to clear the other and them turn off the check boxes.
My question is how can i do this?
As far as I investigate, I don't have nothing similar to when-check-box-change in forms.

My approach to this question ( that doesn't work ) is to define in the query to columns :

CASE WHEN ACCEPTANCE=1 THEN
APEX_ITEM.CHECKBOX(11, "ACCEPTANCE",'enabled','onChange= "test();"')
ELSE
APEX_ITEM.CHECKBOX(11, "ACCEPTANCE",'disabled' ,'onChange= "test();"')
END "Rejected",

CASE WHEN ACCEPTANCE=0 THEN
APEX_ITEM.CHECKBOX(11, "ACCEPTANCE",'enabled','onChange= "test();"')
ELSE
APEX_ITEM.CHECKBOX(11, "ACCEPTANCE",'disabled' ,'onChange= "test();"')
END "Accepted"

the test function is a javascrit function the will disable the other checkbox. At this moment in time the function just send a message. the functiom is tested through a button the message is displayed but when the check box changed nothing happens.

I appreciate if you can help me in this subject.
Thanks
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 24 2011
Added on Feb 24 2011
2 comments
441 views