On Tue, 13 Aug 2002 11:47:55 -0700 (PDT), marc schluter wrote: >Is there a problem using # and _ in col and vars?
marc, You should name things according to the most restrictive program that may be used to access those things. The SQL standard says that allowable characters in names of identifiers are characters, digits, and the underscore character. Some other program adhering to a stricter naming standard than R:Base may want to look at the data through the ODBC driver, and may not recognize the column name. Some people like to avoid the underscore character because it is also the SQL "wild card" character for a single character, and can cause confusion in "LIST COLUMN columnspecification" or "CLEAR VAR varspecification" commands. Bill ================================================ TO SEE MESSAGE POSTING GUIDELINES: Send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: INTRO rbase-l ================================================ TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: UNSUBSCRIBE rbase-l ================================================ TO SEARCH ARCHIVES: http://www.mail-archive.com/rbase-l%40sonetmail.com/
