R:Base has always had very strong typing of columns where columns with the
same name MUST be of the same type. This was always a strong point when the
database was standalone. Who would have forseen the need to avoid this
strong name/type relationship.
-- Dennis McGrath
mailto:[EMAIL PROTECTED]
-- Productivity Tools for R:Base Programmers
http://www.enteract.com/~mcgrath/dennis
-- Full time consultant with:
SQL Resources Group
Steve Hartmann
Oak Park, IL
mailto:[EMAIL PROTECTED]
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On
Behalf Of Dan Weissmann
Sent: Wednesday, August 22, 2001 11:25 AM
To: [EMAIL PROTECTED]
Subject: Re: SCONNECT and Illegal Column Names
Ah, then how do you change the column names when attaching so you can read
the data? I've had RBase prompt me for this when similar problems occurred
in attaching a dbf with the ATTACH command. With SATTACH I just get a
warning.
Dan
----- Original Message -----
From: "Ben Johansen" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, August 22, 2001 10:45 AM
Subject: RE: SCONNECT and Illegal Column Names
> Yes,
>
> Try "SET ANSI OFF"
>
> The other issue is a column name in Sybase is the same name as a column in
> RBase and different data types or length. One of them has to change...
>
>
> Ben Johansen - www.pcforge.com
> list commands: www.pcforge.com/WiTangoTalk.htm
>
> -----Original Message-----
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On
> Behalf Of Dan Weissmann
> Sent: Wednesday, August 22, 2001 7:28 AM
> To: RBase List Server
> Subject: SCONNECT and Illegal Column Names
>
>
> Greetings all. I'm having my first experience of trying to use SATTACH and
> SCONNECT. The table in the foreign source (a Sybase table) appears to
> connect fine, but RBase shows the table as empty (no rows). I also receive
> an error message when connecting which indicates that a few column names
are
> illegal in Rbase. Could this be why RBase sees the table as empty?
>
> Thanks,
>
> Dan
>
>
>
>
