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
