Thank you Razzak, it was the delimit character setting, which had been changed, but not reset (and unfortunately I could not see the difference.) Your help is much appreciated.
Regards, John Docherty -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of A. Razzak Memon Sent: Wednesday, February 09, 2005 1:25 AM To: RBG7-L Mailing List Subject: [RBG7-L] - Re: Format Command At 04:51 AM 2/8/2005, John Docherty wrote: >I have an EEP which includes the following command > >set var xlabm#=(FORMAT(.xlabm,'99.0')) > >This works correctly in one database, but I get an error >"Column or variable xlabm,'99.0' not found (2515)" when >executing the same command in another directory. Xlabm >exists as a real number. > >I have tried executing this at the R> prompt with the same >result, ie one works, the other doesn't. > >Any suggestions as to what I have wrong would be much >appreciated. (I have deleted the RBENGINE.CFG files, copied >them so they are both the same, all to no avail.) John, Check the CHARacter SETtings of other database on other directory. Here's how: 01. CONNECT FirstDB 02. At the R> prompt: SHOW CHAR 03. Change the directory for another database 04. CONNECT SecondDB 05. At the R> prompt: SHOW CHAR 06. Compare the CHARacter SETtings (FirstDB vs. SecondDB) 07. Notice the difference Suggestion: Avoid using special character symbols when defining Column or Variable names. Hope that helps! Very Best R:egards. Razzak. -- No virus found in this incoming message. Checked by AVG Anti-Virus. Version: 7.0.302 / Virus Database: 265.8.6 - Release Date: 7/02/2005 -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.302 / Virus Database: 265.8.6 - Release Date: 7/02/2005
