https://bugs.documentfoundation.org/show_bug.cgi?id=153942
Robert Großkopf <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |[email protected] --- Comment #1 from Robert Großkopf <[email protected]> --- There are different default values. If you create a table in the *.odb-file using the GUI of Base, the default value in this GUI is a static default value, which is shown in any new row of the table when creating a new record. CURRENT_TIMESTAMP isn't a static value for now. 2023-03-10 15:27:04 will be such a value for a default timestamp of the GUI. The same behavior is setting a default value for the GUI in a form. There is no possibility to set a dynamic default value (like CURRENT_DATE, CURRENT_TIMESTAMP) in GUI. You could create such a value by using macro, but it has to change its value while TIME is changing … The default value of the database will be set if there is no value in a column which. The field is empty, NULL. You have to alter the table definition through Tools → SQL for this. -- You are receiving this mail because: You are the assignee for the bug.
