Number to identify the item you want to generate. SELECT APEX_ITEM.CHECKBOX(1,empno,NULL,NULL,NULL,'f01_#ROWNUM#') "Select", This is useful for referencing records from within JavaScript code:
The following example demonstrates how to create unselected checkboxes for each employee in the emp table, with a unique ID. For example, you could have a Delete button that utilizes the following logic:Ĭonsider the following sample on-submit process:įOR I in 1.APEX_APPLICATION.G_F01.COUNT LOOPĭELETE FROM emp WHERE empno = to_number(APEX_APPLICATION.G_F01(i)) If you are using check boxes in your application, you might need to create an On Submit process to perform a specific type of action on the selected rows. The next example demonstrates how to select the check boxes for employees who work in department 10 or department 20. SELECT APEX_ITEM.CHECKBOX(1,empno,DECODE(deptno,10,'CHECKED',NULL)) "Select",
The following example demonstrates how to select the check boxes for employees who work in department 10. SELECT APEX_ITEM.CHECKBOX(1,empno) "Select", The following example demonstrates how to have all check boxes for employees display without being selected. SELECT APEX_ITEM.CHECKBOX(1,empno,'CHECKED') "Select",
The following example demonstrates how to create a selected check box for each employee in the emp table. Value of a check box, hidden field, or input form itemĬontrols HTML tag attributes (such as disabled)ĭelimits the values in the previous parameter, p_checked_values For example 1 creates F01 and 2 creates F02 Number that determines which APEX_APPLICATION global variable will be used.