Hello fellow Developers.
I am currently working with JDeveloper Version 12.2.1.4.0.
So i got an Entity based ViewObject with some Attributes and a String (Varchar2(1)) Attribute that can only hold ‘J’ or ‘N’.
I used the DataControl to create a Table and now i need to enter ‘J’ or ‘N’ into the inputField to enter a Value for the column. Thats not very user friendly so i want to create a selectBooleanCheckbox for this Attribute. So i rightclick the InputField and convert it to selectBooleanCheckbox:
Now when i start the Application and click on the createInsert button refering to the table i get a popup window with following error: Value False For Field LeukoseUntersuchung Exceeds The Maximum Length Allowed.
Whats also very curious is the fact that for every row that i have in the table the selectBooleanCheckboxes are unselected despite that some rows have the value ‘J’ in database.
So after this attempt i tried a different approach: i deleted the column in my table and dragged the column from the datacontrols directly as a selectBooleanCheckbox into my table (instead of converting the inputField into a selectBooleanCheckbox that was created by dragging the whole table into my page)
When i now click on createInsert no error pops up. I enter the data for the row, click on the selectBooleancheckbox so its state is selected and commit after that.
Now i encounter a different problem: the commit/rollback (Speichern/Abbrechen) buttons stay active and nothing happens.
If i click the commit button for a second time the commit/rollback buttons get inactive:
Normally the ID should be a valid positiv value now after the commit has happened. But it is not. (its a DatabaseSequence (value is set by database trigger))
After that i refresh the page with F5 and this happens:
The selectbooleancheckbox is unselected. But the row now has its ID.
If i now check the selectBooleanCheckbox because i want it to have a selected state, the commit button stays inactive:
Can someone please help me to fix this?