To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=100467 Issue #|100467 Summary|changes in standard values of the table do not get sav |ed Component|Database access Version|OOO310m7 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 u...@openoffice.org Sun Mar 22 22:46:40 +0000 2009 ------- I created an table in HSQLDB with integer fields. I set default values. Later i want to change the default value by using the edit tables menu. But the changes do not get saved. I want to create an example but there were a lot of different results so i do not get the one working way. Please play a little bit like: change default values, save, close table, refresh tables, edit tables again. Important is to click the view/Refresh tables button. -Please notice, this example was build with OOO310m7 -Open attached Database -right click to open the table "Example" -go to row "ONE" and change default value from 1 to 10 -save table by clicking -go to row "TWO" and change default value from 3 to 20 -save table by clicking => You can see that the default value is lost in field "ONE" -close table -click on view/Refresh tables -edit table "Example" again => In my example the default values always go back to previous values after doing this => If i rename the column sometimes i get the default value for the row saved. => Once i couldn't get any default values in 310m7 any more, but after opening the same file in OOo3.0.1 the default values from before where back again, also in OOO310m7. --------------------------------------------------------------------- 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: issues-unsubscr...@dba.openoffice.org For additional commands, e-mail: issues-h...@dba.openoffice.org --------------------------------------------------------------------- To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
