Claus Pedersen
Member³
When editing a table in SQL window, it would be nice to have a background colour to indicate that the field is NULL, but the current column is mandatory (so you will get an ORA-1400 when inserting).
Today you have to insert/update (and get the error) or you should cycle through all columns and read the column properties at the bottom of the screen to ensure that all mandatory columns are filled in.
The background colour for this could be orange or another warning colour (should not conflict with the red Compare records colour).
E.g. when editing the table scott.EMP, the cell for empno would be orange until a value was entered.
Today you have to insert/update (and get the error) or you should cycle through all columns and read the column properties at the bottom of the screen to ensure that all mandatory columns are filled in.
The background colour for this could be orange or another warning colour (should not conflict with the red Compare records colour).
E.g. when editing the table scott.EMP, the cell for empno would be orange until a value was entered.
