Keith Clark wrote:
At 10:09 14/06/2008 -0400, Keith Clark wrote:
How can I change the size of a field after I've created it?
After creating a table, I cannot go back and edit a field. Base
will not allow me to do that. They are all greyed out.
Barbara replied:
You don't seem to be getting a lot of answers here, maybe because others
haven't had this experience -- I've generally had no problem with making
changes, so I don't know just what you're running into here. What OOo
version and OS are you running? Is there a primary key? Is that what you
are trying to change, or something else? Anyway, one thing that should
definitely work is to create a new table with the specs you want, then
right-click the name of your current table and choose Copy. Still in the
same pane, paste (Ctrl-V works fine) to bring up the import wizard, and
fill in the name of your new table, then the option to append the data.
You proably should run through the various "Next" options to make sure
everything is as expected, then Create. This should pick up all your
data properly into the new definition. If you had some queries, forms,
or reports based on the old table, you'll need to delete or rename the
original table and give the new version the correct name. The queries
should then work fine, but the forms and reports may need
tweaking/redefinition, depending on what kinds of changes were made..
I also tried in an SQL window:
alter table "table" alter column "column" varchar(255)
and all worked out.
Thank you for your reply though, I appreciate all the help I can get.
Keith
Glad you found a fix. By any chance, had you closed and reopened the
database, or restarted, between the problem and the fix? It occurred to
me after my previous response that maybe something was locked, since
normally there's no issue with doing this kind of thing. It would be
nice to know what blocked the GUI table design, in case somebody else
runs into the same problem, but it doesn't seem to be too common.
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
