On Tue, 2008-06-17 at 15:39 -0500, Barbara Duprey wrote: > 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.
Once I've created a table, I can never go back and edit the fields again. They are always greyed out and I have to use SQL commands to do the modifications. I can add fields to tables with no issues. Also, once I've changed the appropriate value via SQL, close the table and then re-open it, the field definition, although still grey, shows the correct, new value. This has always frustrated me to no end with Base. Keith --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
