https://bugs.documentfoundation.org/show_bug.cgi?id=104375
--- Comment #5 from rob...@familiegrosskopf.de ---
This is the same behavior for every column in the table, not only for
date-columns:
You could create a value, which is written in the table through the GUI. This
is the "Default" of the GUI. It is the same behavior in a form: The fields of a
form have such a default-value. Has nothing to do with SQL.
You could create a value through SQL. This is the default-value of the
database. This is the default other users of a server-database will work with,
too.
If the field of the table has no content and nothing has been changed in this
field, there will be only an INSERT for the fields with content. If you delete
the GUI-default, there will be submitted NULL to the database for this field.
So it is impossible (for input in the table directly or with a GUI-default in a
form) to get the default-value for the database. You could say: This is the
first bug.
INSERT INTO "TEST2" ("NAME") VALUES ('Tim')
would set the default for the column "TESTDATE". The SQL-default will be only
set by a database, if the field isn't part of the INSERT-command.
What you wish: Set the default of SQL to the default of GUI. The values will be
shown before inserting into the table. The SQL-default of the table will never
been executed any more for fields, which are shown in the GUI. You could say
this is the second bug.
... and the third bug is: The values for GUI-default of the date seem to be
totally wrong between what is saved in the table-definition and shown in the
table afterwords.
--
You are receiving this mail because:
You are the assignee for the bug._______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
