[Libreoffice-bugs] [Bug 138412] LO base editing forms - probably works as intended: defaults in table are overruling defaults in form

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=138412

--- Comment #7 from Robert Großkopf <robert at familiegrosskopf.de> ---
Only in a development version of LO you could create Firebird databases without
activating the experimental features. The migrating wizard is also an
experimental feature. If you don't write down which database you are using we
are thinking: The bug is described for the defaul database in LO, the (old)
internal HSQLDB.

Seems the version you selected is wrong. The screenshot you made is from such a
development version, not with LO 7.0.3.1

The behavior in this bug-description is the same in HSQLDB, because this is
part of the GUI since the beginning of OOo:
Creating a table in the GUI offers a field for input a value, which should be
written in a new row of the table when a new row will be opened for input data.
And so the new row in a form will be created with this values.
The controls in the form will recognize: There is a value, we shouldn't set a
new standard value. The standard value will only work for fields, which are
NULL and for new rows.

The real default value you are looking for isn't the value you created in the
GUI of the table. It must be created by Tools → SQL. This will set the default
when submitting the new row to the database with fields, which are NULL and
shouldn't be NULL.

I won't confirm this behavior as a bug.

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20201123/de9774ef/attachment.htm>