Apache OpenOffice (AOO) Bugzilla – Issue 104968
The display times for standardvalues from tables beetwen GUI/SQL vary
Last modified: 2017-05-20 11:35:21 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
Created attachment 64679 [details] Example
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.
Reset assigne to the default "issues@openoffice.apache.org".