Triggers in checkbox apex
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