Toad World® Forums

Format errors cancels insert in data grid

I have the following table and try to insert a new row in data grid:

CREATE TABLE toad_test ( id NUMBER(1) NOT NULL, ts TIMESTAMP );

If I provide a ts but no id and confirm, I get this error as expected

ORA-01400: cannot insert NULL into ("X"."TOAD_TEST"."ID")

I can continue to edit that row.


If I enter an invalid date I get exceptions like these as expected

ORA-01858: a non-numeric character was found where a numeric was expected
ORA-01843: not a valid month

The new row vanishes though without a chance to fix the problems.

Thanks Peter, I see that. I've logged it and will fix it soon.