To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=78296
Issue #|78296
Summary|adding a column to a HSQLDB table which is referred in
| a view renders the database useless
Component|Database access
Version|OOo 2.2
Platform|All
URL|
OS/Version|All
Status|NEW
Status whiteboard|
Keywords|
Resolution|
Issue type|DEFECT
Priority|P2
Subcomponent|none
Assigned to|fs
Reported by|fs
------- Additional comments from [EMAIL PROTECTED] Mon Jun 11 09:53:45 +0000
2007 -------
- open the attached database document
- select the "Tables" section in the left pane
- open the table "abc" for editing ("Edit" in its context menu)
- add a new column named "d"
- press the same button
=> an error message pops up saying the table could not be saved
- click away this error message
- close the table design, not saving the changes this time
- open the table "abc" by double-clicking it
=> note that the column "d" has actually been added
- close the table
- close the database document
- re-open the database document
- try to establish a connection by clicking onto "Tables"
=> an error message pops up saying the connection could not be established
After this, you cannot use the complete database, unless you manually unzip the
.odb, edit the script file, and re-pack the files.
---------------------------------------------------------------------
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]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
