-
Bug
-
Resolution: Done
-
Minor
-
8.6
-
None
When creating a virtual insert procedure and omitting a non-nullable column from the insert, the error message is simply
ERROR: ERROR
E. g. I have a PUBLISHERS table with three columns, of which PUBLISHER_ID is NOT NULL, the insert procedure is
FOR EACH ROW BEGIN ATOMIC INSERT INTO Books.PUBLISHERS (Books.PUBLISHERS.NAME) VALUES ("NEW".NAME); END
The error in previous versions of Designer for the same procedure would be
ERROR: Element Books.PUBLISHERS.PUBLISHER_ID of books.publishers is neither nullable nor has a default value. A value must be specified in the insert.