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",
and the process looks like
for i in 1..apex_application.g_f01.count
set STATUS= apex_application.g_f06(i), first_name=apex_application.g_f07
where pa_number= apex_application.g_f01(i);
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.
But this is something I got from Denes Kubicek demo application,
in which he shows if its a manual tabular form, we can perform multi row updates.
Can you help me with achieving this.
I need to update multiple rows based on the checkbox selected.
MRU with wizard tabular forms doesnt make use of the checkboxes.
Please read my blog about APEX checkboxes. It explains why the wrong rows are updating in your case, and it will help you to rework your report to doing as you expect.
In Denes example check box value is row index.
Let say you check row 5 in example.
When you submit page f01 array holds one value. And that one value is 5 because you did check row 5.
From other arrays f02..f05 he fetch by that value.
In your case f01 seems hold primary key value.
Loop is from 1 to f01.count.
Fetch other arrays you use loop counter. And if you check only one row you get first value from other arrays .