Ah, but Emmitt's original didn't say and I did remember to specify where my answer came from in case it was out of date <g>.
That said, when did # begin to represent the pound? £ has always been good enough for us this side of the pond and I don't remember anyone saying it had been changed!!! Regards, Alastair. From: Paul InterlockInfo Sent: Tuesday, March 30, 2010 3:37 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: column names Alastair- From 9.0 Help: 'Valid names must start with an alpha character and can include the following symbols: Letters (A-Z); Numbers (0-9); # (pound sign); _ (underscore); $ (dollar sign); % (percent sign). Spaces are NOT permitted. Also, for ODBC compliance, it is not recommended to use the # (pound sign) symbol in a column name even though R:BASE permits it.' I get a RDCC report from testing Emmitt's issue. A first for me <gig>. Sincerely, Paul Dewey From: [email protected] [mailto:[email protected]] On Behalf Of Alastair Burr Sent: Tuesday, March 30, 2010 10:28 AM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: column names From the v7.6 help: Table and column names can be a maximum of 18 characters and must begin with an upper- or lowercase letter. Names can contain letters, numbers, and the following special characters: #, $, _, and %. R:BASE verifies that a table or column name is unique by reading all 18 characters. Regards, Alastair. From: Emmitt Dove Sent: Tuesday, March 30, 2010 3:15 PM To: RBASE-L Mailing List Subject: [RBASE-L] - column names Is there an issue using column names that begin with numbers? e.g: 204lastsent 204ver 220recd 220ver Thanks in advance. Emmitt Dove Manager, Converting Applications Development Evergreen Packaging, Inc. [email protected] (203) 214-5683 m (203) 643-8022 o (203) 643-8086 f [email protected] ---------------------------------------------------------------------------- No virus found in this incoming message. Checked by AVG - www.avg.com Version: 9.0.791 / Virus Database: 271.1.1/2779 - Release Date: 03/30/10 07:32:00 ------------------------------------------------------------------------------ No virus found in this incoming message. Checked by AVG - www.avg.com Version: 9.0.791 / Virus Database: 271.1.1/2779 - Release Date: 03/30/10 07:32:00
