Barbara Duprey wrote:
I'd have thought that "VARCHAR" would automatically expand as needed
up to at least 255, but it doesn't, and the field definitions cannot
be modified in place. The option is presented to delete the field and
append a new one as redefined, but that discards all the data. (Issue 2).
That was a problem with versions of OOo up to 2.2.1. In the current 2.3
developers build you can enlarge the size of a varchar field, in place.
Also - in the earlier versions you can do it also, but not using the GUI
table editor. You must use an actual SQL DDL ALTER TABLE ALTER COLUMN
command from the SQL window.
The syntax for that command can be found in the HSQLdb Users Manual, and
that document can be found at http://hslqdb.org
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
