Hello there
I have a report as below with 2 checkboxes , if I have one I can process the changes with no errors but 2 I can't get to work despite reading blogs , posts etc , they all deal with one checkbox
Query is as below
SELECT
apex_item.hidden( 1,NOTIFICATION_ID)||
APEX_ITEM.CHECKBOX(
p_idx => 2,
p_value => APPROVE,
p_item_id => 'f02_#ROWNUM#',
p_checked_values => 1) APPROVE,
apex_item.hidden( 1,NOTIFICATION_ID)||
APEX_ITEM.CHECKBOX(
p_idx => 3,
p_value => REJECT,
p_item_id => 'f03_#ROWNUM#',
p_checked_values => 1) REJECT,
APEX_ITEM.TEXT(
p_idx => 4,
p_value => COMMENTS,
p_size => 100,
p_item_id => 'f04_#ROWNUM#',
p_maxlength => 250) MC,
NOTIFICATION_ID
from notification
where status = 4
order by notification_id desc
When i select as below it works
when i select as below it gets a NO DATA FOUND error
the process to update is
BEGIN
FOR i IN 1..apex_application.g_f02.count LOOP
UPDATE notification
SET approve = decode(apex_application.g_f02(i),0,1) ,decision_date = sysdate,
comments = apex_application.g_f04(i)
WHERE notification_id = to_number(apex_application.g_f01(i));
END LOOP;
FOR i IN 1..apex_application.g_f03.count LOOP
UPDATE notification
SET reject = decode(apex_application.g_f03(i),0,1) ,decision_date = sysdate,
comments = apex_application.g_f04(i)
WHERE notification_id = to_number(apex_application.g_f01(i))
END LOOP;
END;
vers - Application Express 20.2.0.00.20
any help most gratefully received as i've tried everything
Cheers
Chris