David
CONTI is a reserved word CONTINUE Buddy From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Lawrence Lustig Sent: Monday, November 17, 2008 9:35 PM To: RBASE-L Mailing List 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
