RBase friends
Thanks for all your suggestions about the renaming column issue. Finally it dawned on me - the error message was not completely clear and led me down the wrong path. Bill, your message that you recreated my columns / tables and got it to work turned the light bulb on. The message: COLUMN ADD_ not found was actually NOT referring to the ALTER TABLE command itself. This is a very wide and complex table with 6 complex COMPUTED columns in it and FIVE of them referred to one or more of the columns I was trying to rename. THAT's what the error message was about - R:Base couldn't do rename of the column because that would mean the definitions of those COMPUTED columns would have been invalid, referring to a column that no longer existed. So, by temporarily ALTERing the computed columns to REMOVE the computed column definitions, then recreated the computed definition AFTER the columns with the _ were renamed, did the trick! So many thanks - problem solved. David Blocker David Blocker [EMAIL PROTECTED] Telephone: 781-344-1920 Cell Phone: 339-206-0261 ----- Original Message ----- From: Bill Eyring To: RBASE-L Mailing List Sent: Wednesday, November 19, 2008 11:53 AM Subject: [RBASE-L] - RE: Problem renaming columns David, I created the table payroll with your column names in an existing 7.1 database. I was able to use your alter command successfully for the columns ADD_ and STD_. Trying to rename CONT_ to CONTI was unsuccessful. However I was able to change CONT_ to BILL. Must have something to do with CONT being a reserved word. Possible reserved word hangups are CONTAINS & CONTINUE. Here are my character settings. BLANK DELIMIT , LINEEND ^ SEMI ; QUOTES ' PLUS + SINGLE _ MANY % IDQUOTES ` Hope this helps. Bill Eyring ------------------------------------------------------------------------------ From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of David Blocker Sent: Monday, November 17, 2008 9:25 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Problem renaming columns In an application using R:Base 7.1, I have three columns named: ADD_ CONT_ STD_ R:Base permitted me to create these columns when I built the database. The user would now like me to rename these fields as follows: ADD_ to ADDL CONT_ to CONTI STD_ to STDP These commands fail when I try to rename the columns: ALTER TABLE PAYROLL ALTER COLUMN ADD_ to ADDL CURRENCY ALTER TABLE PAYROLL ALTER COLUMN CONT_ to CONTI CURRENCY ALTER TABLE PAYROLL ALTER COLUMN STD_ to STDP CURRENCY R:Base the error messages: COLUMN ADD_ not found COLUMN CONT_ not found COLUMN STD_ not found I thought it might a problem with the SINGLE wild card character, so I typed: SET SINGLE='?' I continue to get the same messages, yet: LIST COLUMN ADD_ LIST COLUM CONT_ LIST COLUMN STD_ all show the correct columns. Any ideas of how to get around this to rename the columns? David Blocker David Blocker [EMAIL PROTECTED] Telephone: 781-344-1920 Cell Phone: 339-206-0261 ------------------------------------------------------------------------------ No virus found in this incoming message. Checked by AVG - http://www.avg.com Version: 8.0.175 / Virus Database: 270.9.7/1798 - Release Date: 11/18/2008 8:59 PM
