To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=105237
User atjensen changed the following:
What |Old value |New value
================================================================================
CC|'' |'atjensen'
--------------------------------------------------------------------------------
Issue type|DEFECT |ENHANCEMENT
--------------------------------------------------------------------------------
Keywords| |usability
--------------------------------------------------------------------------------
Summary|Update in text table creat|[HSQLdb] GUI shuold offer
|es blank lines |the ability to compact dat
| |a files
--------------------------------------------------------------------------------
------- Additional comments from atjen...@openoffice.org Tue Sep 29 04:50:21
+0000 2009 -------
@schaber - Well it isn't actually a work around, it is as designed by the HSQLdb
project team.
With the Base file opened and connected. (meaning you need to enter the table
section or be displaying data in a form)
Open menu item: Tools>SQL
Enter, and execute, the command: SHUTDOWN COMPACT
You will need to close the Base file at this point - the blank lines are removed
from any attached text files.
So I could say this is as designed or WORKSFORME and call this more a support
query - but instead
@schaber - I hope you don't mind if I use your entry of this issue as a specific
use case for a more generalized issue.
"Update in text table creates blank lines" is just one instance of when users
need a compact command, to reclaim space in cached tables is another.
Currently the user must use either the CHECKPOINT DEFRAG or SHUTDOWN COMPACT
command in the SQL window. The latter command is required to purge blank lines
from attached text table files and then requires the user to close the Base
file.
My suggestion would be to add a new item to the task list under Tables with the
string:
Compact
A description entry of:
This operation shrinks all files to the minimum size.
Clicking on the task item would:
close any open component windows (forms, dataviews, etc)
execute the SHUTDOWN COMPACT command for the active connection
reconnect the active connection
---------------------------------------------------------------------
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
