APEX

Hello,

i have simple problem:

In a select I have:

SELECT 
abc,
apex_item.hidden(5, ID) || APEX_ITEM.CHECKBOX(4,XYZ, DECODE(XYZ, 'Y', 'CHECKED', NULL)) "XYZ",
abcd,

which works fine.

I want to check some of the boxes and do my submit.

And, in addition, I would like to do an uncheck (+submit) later.

But since it is not possible to get the unchecked Boxes in the After-Submit-Process I have a problem.

Thats why I add the "apex_item.hidden(...)" (to loop against that hidden item).

I thought there shoud be a way. Am I wrong?

Is the following intention completly wrong?

FOR i in 1 .. APEX_APPLICATION.G_F05.COUNT LOOP
        UPDATE myTable SET XYZ = APEX_APPLICATION.G_F04(i) WHERE ID = to_number(APEX_APPLICATION.G_F05(i));
END LOOP;

It does not work, because there are some unchecked check boxes.

And APEX_APPLICATION.G_F04(i) is null or something like that.

Does anybody know a solution?

Or do I really have to use JS/Dynamic Actions?

kind regards,

ilb