I have a ‘hierarchial’ table of the form:
CREATE TABLE functions (
id RAW(16) DEFAULT ON NULL sys_guid() NOT NULL,
name VARCHAR2(80) NOT NULL,
description CLOB,
sibling_order NUMBER NOT NULL,
func_id_parent RAW(16)
);
I used the page wizard to create a stacked master-details form where the master and detail refer to the same table (id on the master IG form is referred to by func_id_parent on the details IG form).
This generally works in that I can update the name, description and sibling_order columns.
I can also use the row delete option to remove a details entry.
However, I cannot update the func_id_parent column - it appears to change in the IG form, but when saved, it reverts to the original value.
Is this by design? Something to do with the func_id_parent having been defined as the master-detail reference?
Any ideas? It ‘would be nice’ to move a hierarchical tree from one master to another on this page.