No, Paul, there is no error report if the help says ". must start with an alpha character ..." That means to me that a column name cannot start with a number. It didn't show up as an error, however, until I tried to use it in code - CREATE TABLE did not complain.
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] From: [email protected] [mailto:[email protected]] On Behalf Of Paul InterlockInfo Sent: Tuesday, March 30, 2010 10:38 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 <ms-its:RBG90.chm::/odbc_glossary.htm> 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 <mailto:[email protected]> Dove Sent: Tuesday, March 30, 2010 3:15 PM To: RBASE-L Mailing List <mailto:[email protected]> 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
