Les, If you look at SYS_COLUMNS and sort by column name you'll see one entry for each occurrence of the column in question. Therefore, you cannot change the column definition in one command or action, since when the first change is attempted it will violate R:BASE's internal data integrity rules.
You must write the code to rename all but one, resize the final one then alter the other columns one at a time to the new definition. Emmitt Dove Manager, Converting Applications Development Evergreen Packaging, Inc. [email protected] (203) 214-5683 m (203) 643-8022 o (203) 643-8086 f [email protected] -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Les Stark Sent: Tuesday, October 19, 2010 14:42 To: RBASE-L Mailing List Subject: [RBASE-L] - Changing a column width in many tables Is there a simple way to change a column width that exists in many tables without renaming the column in each table? Perhaps using the sys tables? --
