Hi,
In APEX 5.04 I have in some tables GUID for a primary key. For easy explanation, let's say I have a Parent and a Child table. Parent have GUID for Primary Key. Then I create "Form on a Table with Report" for a Child table. For field from the parent table, I'm using Select List and LOV from the parent table. When I create new child records all work fine. The problem shows up when I edit existing record. then the value of the parent field is not displayed anymore (even if I'm not using Select list).
When I edit any of above existing records I get the empty field as shown below (actual values are in the field in SQL Developer):
For this example I'm using the next DDL code:
Create Table TEST_P2
(
ID Raw(16) Not Null,
Name VarChar2(15 Char)
);
Create Table TEST_C2
(
ID VarChar2(10 Char) Not Null,
User_ID Raw(16) Not Null,
Description VarChar2(15 Char)
);
Alter Table TEST_P2 Add Constraint TEST_P2_PK Primary Key (ID);
Alter Table TEST_C2 Add Constraint TEST_C2_PK Primary Key (ID);
Alter Table TEST_C2 Add Constraint TEST_C2_P2_FK Foreign Key(User_ID) References TEST_P2(ID);
If I use instead of GUID regular Number field all work fine. What I'm doing wrong here and why the value is not displayed, even if I'm not using LOV and I use just Text Field?
BB