[Libreoffice-bugs] [Bug 104375] Table Default value for Date cannot be modified using SQL

[bugzilla-daemon]

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

--- Comment #7 from Stang  ---
Sorry - bug mentioned in last comment should be bug 102945.

-- 
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

[Libreoffice-bugs] [Bug 104375] Table Default value for Date cannot be modified using SQL

[bugzilla-daemon]

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

--- Comment #6 from Stang  ---
OK.  I've read your comments and can accept what you state about GUI vs a table
field default.

To me, your "first bug" and "second bug" are one and the same.  I don't see any
difference between the field default in the table and the GUI default.

As you previously mentioned, bug 104375 covers the "third bug". Actually that
is partially where this whole thing started.  Of note, TABLE3 (default set by
ALTER only) produces correct dates when entering records in GUI; it just
doesn't display them until tabbing through the field.  So it seems this may
also take care of "third bug" if GUI & field default were the same.

One other point.  Your last statement:

"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."

is somewhat the basis for this bug.  The referred to table-definition here is
in the "content.xml" file.  This is certainly a point of confusion since it has
absolutely nothing to do with the table in the database.  Just a point.

I can understand why this is not a simple change, nor is the list of bugs short
but this is a bug and not an enhancement.  Fortunately there are ways to work
around this for the time being as mentioned in "Additional Info".

Thank you for your patience and time thus far.

What if anything else is needed?

-- 
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

[Libreoffice-bugs] [Bug 104375] Table Default value for Date cannot be modified using SQL

[bugzilla-daemon]

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

[Libreoffice-bugs] [Bug 104375] Table Default value for Date cannot be modified using SQL

[bugzilla-daemon]

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

--- Comment #4 from Stang  ---
I should also point out, in the sample provided, if you edit table "TEST1" and
look at field "TESTDATE" there is a default date of "12/05/16" (the actual
value doesn't matter, just that there is something there).  With that, run the
provided query "TABLE1SCHEMA" and you will see there is no default date set.

Of what value is there to create a table when what is specified is not done? 
If this table is accessed outside of LO there is no default date!  Nothing to
do with GUI, just the table definition itself.

It also creates questions as to what else is not being done in Base when adding
fields or tables.

-- 
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

[Libreoffice-bugs] [Bug 104375] Table Default value for Date cannot be modified using SQL

[bugzilla-daemon]

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

Stang  changed:

   What|Removed |Added

Summary|Default dates in table  |Table Default value for
   |creation incorrect  |Date cannot be modified
   ||using SQL

-- 
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