Apache OpenOffice (AOO) Bugzilla – Issue 41785
Unable to edit field definitions and types in a hsqldb table
Last modified: 2007-05-21 03:12:35 UTC
Fields (names, data types) in HSQL-based tables cannot be modified after the table has been saved. It is, however, possible to delete the existing fields. To reproduce the bug: 1. Create a new HSQL database. 2. Create a nre table. 3. Add some fields. 4. Save table and close. 5. Re-open the table in Design View. 6. The existing fields are not modifiable, but can be deleted. The issue has been confirmed by other users (see http://www.oooforum.org/forum/viewtopic.phtml? t=16591)
confirming on Linux also, setting OS to all, and the oooqa keyword alex
That would be nice, however I think it's (currently) a limitation of the used hsqldb database engine. However we should have a look if we can change this. confirm, set target and reassign to the right developer Bye Marc
change summary
At the moment this is not possible. Further information can be found here http://hsqldb.sourceforge.net/doc/guide/ch08.html#alter_table-section , but it is valid RFE so I send it there.
Why not possible ? Isn't it this command ? : ........................................ ALTER TABLE <tablename> ALTER COLUMN <columnname> {RENAME TO <newname> | DROP DEFAULT | SET DEFAULT <defaultvalue>}; Changes column name. Or adds or drops the default value. ........................................
Hello Ocke, as it is a defect, it is wrong on the owner 'requirements'. Do you see a chance to get this fixed for OOo 2.0?
Hi Bettina, I'm sorry, I just forget to set this ot RFE :-) HSQLDB in it's current state can't simply modify existing column definitions. So this issue is a RFE. Best regards, Ocke
Ok, so this one is set to office later.
This one is now implemented in CWS hsqldb4. However, it's not yet decided whether this will be part of 2.0, as the change may have a sever impact on other functionality, which needs careful testing to prevent regressions. In the current state towards 2.0, this might be too late ...
fixed in CWS hsqldb4
*** Issue 45620 has been marked as a duplicate of this issue. ***
*** Issue 46543 has been marked as a duplicate of this issue. ***
*** Issue 46660 has been marked as a duplicate of this issue. ***
change target to 2.0 (approved by TZ)
fs-> msc: please verify in CWS hsqldb4 re-open issue and reassign to msc
reassign to msc
reset resolution to FIXED
verified in cws hsqldb4
*** Issue 45507 has been marked as a duplicate of this issue. ***
Hi, fixed in current developer build (version 1.9.m94)-> close. The current developer build can be found at http://download.openoffice.org/680/index.html Feel free to reopen if this issue is not fixed in the developer build. Bye Marc
*** Issue 47400 has been marked as a duplicate of this issue. ***
Although this problem is marked as resolved, it has reproduced itself for me. I am using OOo 2.0.1, KDE and FC4. I have exactly this problem, although when I use OOo on a machine using Win2000 I cannot reproduce the problem.
I've been searching around and I think this is the right issue, but if not, please point me to the right place. Though this issue is marked as CLOSED and FIXED it doesn't seem to be. First, the particulars: Platform: WinXP Pro SP2+ ProductName: OpenOffice.org ProductVersion: 2.2 SolarVersion: 680 DBMS: HSQLDB 1.8.07 (In SERVER mode) If one opens the BASE document and selects an existing table to edit the ability to edit either the Description or the Format of the column is disabled. Thus the problem. It should always be possible to edit both the Column Description and the Format of the Column. Please note that these are, to my limited knowledge, concepts internal to the Office. Description seems to map to HelpText and Format to the NumberFormat Service (or something like that). Interesting variations on the problem. If the DataSource is ODBC the behavior is as described above. If the DataSource is ADO then both Description and Format is editable plus (in the box to the right) the text is: "This is where you determine the output format of the data." where as, in the previous two cases, the box is blank. Please advise. Thanks, Jeff