R devel - Nov 2004 - colnames argument in sqlFetch backwards? (PR#7355)

Full_Name: Bert Gunter
Version: 2.0.0 patched
OS: Win2000
Submission from: (NULL) (192.12.78.250)


The TRUE/FALSE options of the colnames argument in sqlFetch (RODBC) seem to be
reversed, at least for .xls files.

## z is a connection to an xls workbook opened by odbcConnectExcel()
> dat<-sqlFetch(z,'SuccessRates',colnames=FALSE)
> dat[1:5,]
  RecID     Name Run  Grams Lost Run (80L)
1    NA Activase 117 839.91              0
2    NA Activase 118 860.52              0
3    NA Activase 119 921.23              0
4    NA Activase  NA     NA              1
5    NA Activase 120 722.62              0
> dat2<-sqlFetch(z,'SuccessRates',colnames=TRUE)
> dat2[1:5,]
  NA Activase 117 839.91 0
2 NA Activase 118 860.52 0
3 NA Activase 119 921.23 0
4 NA Activase  NA     NA 1
5 NA Activase 120 722.62 0
6 NA Activase 121 762.48 0

I note also that the last column, "Lost Run (80L)," was actually
TRUE/FALSE and
some blanks in the Excel sheet and was silently coerced to numeric. This is no
problem, of course, but I wonder if it's the intended behavior and, if so,
is it
documented?

Do read the FAQ and stop abusing R-bugs in this way.
I did ask privately, but you have continued to ignore my request.

BDR

On Tue, 9 Nov 2004 bgunter@gene.com wrote:
> Full_Name: Bert Gunter
> Version: 2.0.0 patched
> OS: Win2000
> Submission from: (NULL) (192.12.78.250)
> 
> 
> The TRUE/FALSE options of the colnames argument in sqlFetch (RODBC) seem to
be
> reversed, at least for .xls files.
> 
> ## z is a connection to an xls workbook opened by odbcConnectExcel()
> 
> > dat<-sqlFetch(z,'SuccessRates',colnames=FALSE)
> > dat[1:5,]
>   RecID     Name Run  Grams Lost Run (80L)
> 1    NA Activase 117 839.91              0
> 2    NA Activase 118 860.52              0
> 3    NA Activase 119 921.23              0
> 4    NA Activase  NA     NA              1
> 5    NA Activase 120 722.62              0
> 
> > dat2<-sqlFetch(z,'SuccessRates',colnames=TRUE)
> > dat2[1:5,]
>   NA Activase 117 839.91 0
> 2 NA Activase 118 860.52 0
> 3 NA Activase 119 921.23 0
> 4 NA Activase  NA     NA 1
> 5 NA Activase 120 722.62 0
> 6 NA Activase 121 762.48 0
> 
> I note also that the last column, "Lost Run (80L)," was actually
TRUE/FALSE and
> some blanks in the Excel sheet and was silently coerced to numeric. This is
no
> problem, of course, but I wonder if it's the intended behavior and, if
so, is it
> documented?
> 
> ______________________________________________
> R-devel@stat.math.ethz.ch mailing list
> https://stat.ethz.ch/mailman/listinfo/r-devel
> 
> 
-- 
Brian D. Ripley,                  ripley@stats.ox.ac.uk
Professor of Applied Statistics,  http://www.stats.ox.ac.uk/~ripley/
University of Oxford,             Tel:  +44 1865 272861 (self)
1 South Parks Road,                     +44 1865 272866 (PA)
Oxford OX1 3TG, UK                Fax:  +44 1865 272595