David, The list of reserved words is rather overwhelming to memorize.
You can copy and paste your code into a New File in RBEdit and then review it by Editing and any reserved words will show in Bold Black under default settings and in your situation of course, CONT_ not a reserved word since it has the underscore, however, the word CONT is a reserved word as taken from CONTINUE or CONTAINS and it will show in Black Bold as do all other reserved words in the code snippet. I suggest that you copy code into an RBEdit file and then review for reserved words when you encounter this problem. This will enable you to spot the error quickly. Possibly someone else has a better way, but this works for me. George Baker ----- Original Message ----- From: Bill Eyring To: RBASE-L Mailing List Sent: Wednesday, November 19, 2008 10: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
