Date fields can revert to NULL when adding new rows
When adding a new row that contains date fields the fields are defaulted to today's date/time. However when you tab through those fields they revert to NULL unless so specifically select a date using the picker or re-type it in.
Dazz Knowles
shared this idea
Please note that once you click the ‘Refresh’ button on the toolbar of Data Editor, the correct data will be displayed instead of the NULL value.
-
Dazz Knowles
commented
In 6.0.441 the inconsistency between your UI and MySQL has been fixed so rather than displaying the date after I tab out of it the column resorts to it's original blank state which is correct as then it's obvious that the appropriate default will be used according to the server/column configuration in place. This is much better and no longer confusing, thanks.
-
AdminDevart
(_, Devart)
commented
Please note that this value is returned by the MySQL server and dbForge just displays it. Please check the value of the 'sql_mode' MySQL server variable that is responsible for this.
-
Dazz Knowles
commented
No, this doesn't work. Just rested it on 6.0.399 and unless I specifically click on a date (or the Now) button on the datepicker the row just shows null (or 00-00-00...) if the row does not allow nulls.