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

Robert Großkopf <[email protected]> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |[email protected]

--- Comment #4 from Robert Großkopf <[email protected]> ---
You are mixing different problems here. I will only write about 'default
value'.

GUI of Base offers a 'default' value for the tables. It will be saved in the
Base file and will appear every time you create a new row in the table.
GUI of Base offers also a 'default' value for form controls. It could be
different to the value of the table, because it is only saved in the
description for the form control.
Seems you would use the same 'default' here. You have to change the default in
the form for this value. 
Don't know a reason to use such a default value, created in for tables or form
controls, for a date values. It will always be the same date …

Default, created by SQL for the database, won't be shown in a table or a form.
It will be saved if the field will be empty (NULL). To get date with the
current date while saving the data will work with

ALTER TABLE "Table" ALTER COLUMN "MyDate" SET DEFAULT CURRENT_DATE;

-- 
You are receiving this mail because:
You are the assignee for the bug.

Reply via email to