Hi, I am using Application Express 20.1.0.00.13. I have an IG with a query that involves joins. I wrote a custom process to update a specific table when a specific column's value changes and the user clicks the SAVE button of the IG. I delete the automatic row processing process. All columns are read only except for one that the user can change it's value. I used a submit button and it works pretty fine. But it submit the whole page then renders it again. I just want to save the IG without submitting the whole page. Can I do that with the IG's SAVE button? Or with a custom button?
The query is....
select P.ID PATIENT_ID,
P.NAME,
P.AGE,
J.NAME JOB,
P.PHONE1,
P.PHONE2,
P.EMAIL,
E.STATUS,
C.NAME CITY
from PATIENT P LEFT JOIN CITY C ON P.CITY_ID = C.ID
LEFT JOIN JOB J ON J.ID = P.JOB_ID
JOIN EXAMINATION E ON E.PATIENT_ID = P.ID
The custom process is....
if :APEX_ROWSTATUS = 'U' THEN
UPDATE EXAMINATION SET STATUS = :STATUS
WHERE PATIENT_ID = :PATIENT_ID;
END IF;