Return
-
Title
Editable data grids - not nullable columns set by triggers can't be left null -
Description
While editing or creating a record, if a mandatory column is left null, to be set by trigger, an error is raised saying that 'Field ID must have a value' (where ID is an example of column name).
Previous versions (10.5 and before) didn't have this problem.This error doesn't appear if you try to add data by a script, or in the Schema Browser | Data tab.
It only occurs if you run the following script is run, for example:
select rowid, id,name,created from testcasetable;
Then try to enter the data in the Data Grid of the Editor. -
Resolution
WORKAROUND:
Update the table data in the Schema Browser, or by a SQL scriptSTATUS:
Waiting for fix in a future release of Toad for Oracle -
Defect ID
ST82137