5 Replies Latest reply: Sep 27, 2013 8:30 AM by 1001953 RSS

    Working with tabular forms

    1001953

      Hi,

       

      I want a tabular form on a table in which I can update some of the fields,along with some dynamic actions of disabling some fields and some validations.

       

      I tried creating tabular form using the wizard, but here update process MRU is created by default and even if the checkbox is checked or not, updates can be done by modifying the data.

      What I need is checking the checkbox and modifying the information, and only the checked records should be modified.

       

      I tried creating a manual tabular form and creating a process for updation ,but even if I check the third row and update values, the values are updated with first row values.

      The manualtabular form looks like

       

      select apex_item.checkbox(1,pa_num,'UNCHECKED') "Select Projects",

      org,

      PA_NUM,

      PROJECT,

      SECTOR,

      apex_item.select_list(6,STATUS,'YES;YES,NO;NO') "PROCESS_STATUS",

      apex_item.text(7,first_name,10) first_name,

      apex_item.text(8,last_name,10) last_name

      from "LIST"

       

      and the process looks like

      begin

      for i in 1..apex_application.g_f01.count

      loop           

          update list

          set STATUS= apex_application.g_f06(i), first_name=apex_application.g_f07

              last_name=apex_application.g_f08(i)

              where pa_number= apex_application.g_f01(i);  

      end loop; 

      commit;

      end;

       

      i also tried with assigning apex_application.g_f01(i) into vrow and using vrow instead of i, but then I get an error as no data found.

      Can anyone help.

       

      Thanks.