https://bugs.freedesktop.org/show_bug.cgi?id=45606
Bug #: 45606
Summary: EDITING: Default-value in GUI doesn't work in SQL
Classification: Unclassified
Product: LibreOffice
Version: unspecified
Platform: Other
OS/Version: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Database
AssignedTo: [email protected]
ReportedBy: [email protected]
Created attachment 56592
--> https://bugs.freedesktop.org/attachment.cgi?id=56592
Default_value - on table in GUI, second in SQL. Try to change relationship to
"set default"
When editing the relationship between two tables you could choose: On update -
default. I tried this with a foreign key edited as delault in the GUI. The GUI
shows this default-value. The editing of the realtionship doesn't work. A popup
appears: Missing DEFAULT value ...
When trying this with a table, where the default-value is set by SQL you could
change the relationship to "On update - default".
Seem the default-value in the GUI is only set as a GUI-value. It appears when
editing a new row during editing. When you don't whish the default-value in GUI
you have to delete the default-entry in the row first.
The default-value created in SQL isn't shown in the GUI. The default is set
when saving the new row and the field is already empty. This is the right
behaviour of tables.
If you want to use a GUI-default you could better set the default in
form-controls.
--
Configure bugmail: https://bugs.freedesktop.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
