Hi Everyone,
I have created a "form based on table" to create employee . So there is column "Employee Name" which has : source -> Type: Database Column, and Database Column: EMP_NAME.
I have added a radio box ; when that radio box is selected as Yes, I want "Emp Code" to visible, otherwise it is hidden.
To implement this, on pressing 'Yes' in radio box, I am using "Submit Page" and I have added condition in "Emp Code" to be visible it only when radiobox value is 'Y'
When I am pressing radiobox, page reloads, but any value that I had entered in Employee Name field is lost. But same value gets submitted and is available in session state.
Since for Employee Name; source-> Database Column , I am not allowed to choose Source-> Used -> Only when current value in session state is null.
I have even removed process to fetch rows that means now page doesn't know which database table to use for column's
Then why is that when form reloads it doesn't take values from session state into page fields?
Is it that even though I have removed fetch rows process, but still since field is database column, on reload it tries to take value from database and disregard any value which is available in session state?
I am using APEX 5.1 and Database: Oracle XE112