Dan
Good to know.. I have seen the comment at one time on this list that
it did conflict with some DBMS.. like I said, I'm not sure which one.
Then again... it could just be a glich in the ole processor as well.
Jim Limburg
Dan Goldberg wrote:
>
> I use underscore in R:base 6.5+ for Windows and SQL server all the time
> without incident.
>
> Dan
>
> -----Original Message-----
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On
> Behalf Of Jim Limburg
> Sent: Tuesday, September 18, 2001 8:32 AM
> To: [EMAIL PROTECTED]
> Subject: Re: Single wildcard character
>
> Bob
>
> I have used the underscore in fieldnames for a long while.
> I have heard that other databases... besides rbase choke
> on this.. not sure which, maybe SQL server or ??? If your
> going to ever pull the data into other database products
> then you might want to consider this.
> The other thing I have noted about this is that when you
> go with underscores and longer names ... and you ever
> SCONNECT to the database from another you might end up
> with a small problem...
> I think this is more of a problem with 6.1a -- not sure
> about 6.5 and up.. like you have a name like
> longtablename.long_column_name... it might be interpreted
> between the two connects like longtablename.long_colum_n
> or something.. I'm not quite sure what the limits as far a
> characters are in these situations...
>
> I have to admit that it's been a couple of years ago since
> I ran into this problem, so the exact details I'm fuzzy on,
> but I know it's something like that.
>
> Hope that helps
> Jim Limburg
>
> Bob Powell wrote:
> >
> > Hello everyone:
> >
> > Does anyone know if it's OK to use field names such
> > as: student_address. Does using the underscore which is
> > a single wild card character in R:BASE matter in field
> > names?
> > ----------------------
> > Bob Powell
> > The Hotchkiss School
> > Lakeville, Connecticut
> > Systems Administrator
> > [EMAIL PROTECTED]
