Hi. I am using Oracle APEX 22.1.1.
I created a form based on a sql query that joined two tables...
select r.ID,
r.PATIENT_ID,
r.DOCTOR_ID,
r.DIAGNOSIS,
r.FOLLOWUP_DATE,
r.ROSHETA_DATE,
p.name patient_name, p.age, p.address
from ROSHETA_HDR r join patient p
on p.id = r.patient_id;
I set all columns of table "patient" as query only but when I insert a new record, I always get error "Virtual column not allowed here". Is that normal?