2 Replies Latest reply: Oct 2, 2013 3:49 AM by I_love_bits RSS

    apex_item question

    I_love_bits

      Hy!

       

      I have an Interactive Report with two apex_items:

      select
      ETT_ID,
      APEX_ITEM.HIDDEN(1, ETT_ID) ETT_ID_Hide,
      APEX_ITEM.TEXT(2, Score),
      ...
      

       

      In the text-item I want to fill in numbers and one button should upadate all rows.

      I created a pl/sql process:

      BEGIN
        FOR i in 1 .. APEX_APPLICATION.G_F02.COUNT LOOP
          UPDATE Table_A SET ETT_SCORE = to_number(APEX_APPLICATION.G_F02(i))
          WHERE ETT_ID = APEX_APPLICATION.G_F01(i);
        END LOOP;
      END;
      
      END;
      

       

      Works great if I do not hide the APEX_ITEM.HIDDEN item (means: show it in the Interactive Report as a Standard Report Column).

      But if I hide this item, it will not work anymore.

       

      Does anybody have a solution/workaround?

       

      Or is it possible in the pl/sql process to access ETT_ID itself? something like this: APEX_APPLICATION.ColumneOne(i);

       

      Kind regards,

      ilb