The column default value (sysdate) is ignored when inserting a row into a table using the DB Navigator wizard.
I have a table with a date column with default value sysdate.
In SQL Navigator 6.7.0.2372, when I add a row in this table with the 'plus' sign, the date column stays empty.
When I commit leaving the date column untouched, the column is empty instead of the sysdate.
You need to be signed in and under a current maintenance contract to view premium knowledge articles.
© ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center