David,
Try changing the single/multi setting if it's an underscore to something else.
Regards,
Alastair.
----- Original Message -----
From: David Blocker
To: RBASE-L Mailing List
Sent: Tuesday, November 18, 2008 6:48 PM
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
To: RBASE-L Mailing List
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
------------------------------------------------------------------------------
No virus found in this incoming message.
Checked by AVG - http://www.avg.com
Version: 8.0.175 / Virus Database: 270.9.6/1797 - Release Date: 18/11/2008
11:23
