David,
Have you tried the RENAME command? RENAME COLUMN Add_ TO Addl IN Payroll -Adriana ________________________________ From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of David Blocker Sent: Tuesday, November 18, 2008 12:49 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: Problem renaming columns Larry Yes, I tried your command below as well as these: SET SINGLE='?' 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 They all give the same error messages: COLUMN ADD_ not found COLUMN CONT_ not found COLUMN STD_ not found I even tried connecting the database in R:Base v7.6 for Windows (32-bit), U.S. Version, Build: 7.6.4.30919, but get the same error message. I can change this manually using RBDEFINE, but that would mean a totally unnecessary round trip to the client's site or talking her through it over the phone: this ought to work just fine with the above command. Ideas? David Blocker David Blocker [EMAIL PROTECTED] Telephone: 781-344-1920 Cell Phone: 339-206-0261 ----- Original Message ----- From: Lawrence Lustig <mailto:[EMAIL PROTECTED]> To: RBASE-L Mailing List <mailto:[email protected]> Sent: Monday, November 17, 2008 9:35 PM Subject: [RBASE-L] - Re: Problem renaming columns Try: 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 Note the use of the IDQUOTE character (the backwards apostrophe, located, on my keyboard, to the left of the number 1 key, as the lower case version of the tilde character). First, do SHOW CHAR to make sure that IDQUOTES is set properly. -- Larry ________________________________ No virus found in this incoming message. Checked by AVG - http://www.avg.com Version: 8.0.175 / Virus Database: 270.9.4/1795 - Release Date: 11/17/2008 5:24 PM
