To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=104968 Issue #|104968 Summary|The display times for standardvalues from tables beetw |en GUI/SQL vary Component|Database access Version|DEV300m57 Platform|PC URL| OS/Version|Windows XP Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|none Assigned to|dbaneedsconfirm Reported by|ud
------- Additional comments from [email protected] Thu Sep 10 22:30:40 +0000 2009 ------- 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 --------------------------------------------------------------------- Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
