Issue 104968

Summary: The display times for standardvalues from tables beetwen GUI/SQL vary
Product: Base Reporter: ud <ulger>
Component: codeAssignee: AOO issues mailing list <issues>
Status: CONFIRMED --- QA Contact:
Severity: Trivial    
Priority: P3 CC: issues
Version: DEV300m57   
Target Milestone: ---   
Hardware: PC   
OS: Windows XP   
Issue Type: DEFECT Latest Confirmation in: ---
Developer Difficulty: ---
Attachments:
Description Flags
Example none

Description ud 2009-09-10 23:30:40 UTC
About trying to issue 104901, i found that there is a different, at wich time
default values would be displayed to the user. If you change the default values
in hsql tables by using the GUI, the default values where displayed by opening a
new dataset.

In my oppinion this is a must, because only with this behavior the user can know
where he has to input data.

But if you change the default values by using the /Tools/SQL, the default values
where displayed after leaving the row. This only makes sence if the fields in
forms where not displayed. (An empty field would be filled by user, because he
could never know about this)

Is there a way to change this behavior. Is it possible to get the default values
from the hsql database to the forms or tables to display them, before they where
inserted. The table-GUI doesent know about the values which where set by SQL,
the defaultvalue there is empty.

I did not really know if this is a defect or enhancement.

To get what i mean:
- open attached database
- open "Tabelle1" by double click
- set the courser in "dtText"
=> notice no default values where displayed
- close "Tabelle1"

- open "Tabelle1" in design view
- set default value "dtNumber" to 1
- save and close
- open "Tabelle1" by double click
- set the courser in "dtText"
=> notice default value 1 where displayed immediately

- Open /Tools/SQL
- isert folowing into SQL and execute

alter table "Tabelle1" alter "dtNumber" set default 5
alter table "Tabelle1" alter "dtDatum" set default current_date

- Refresh tables /View/Refresh Tables

- open "Tabelle1" by double click
- set the courser in "dtText" 
=> notice no default values where displayed
- insert some text and leave the row
=> the default values where inserted
Comment 1 ud 2009-09-10 23:31:53 UTC
Created attachment 64679 [details]
Example
Comment 2 Frank Schönheit 2009-09-11 08:22:49 UTC
I am not sure we already have an issue for this, but the problem is known (and
accepted): What you enter in OOo's UI as default value is only a "client-side"
default, "server-side" defaults, i.e. the ones known to the database engine, are
not supported currently.
Comment 3 Marcus 2017-05-20 11:35:21 UTC
Reset assigne to the default "issues@openoffice.apache.org".