[R] RODBC sqlQuery question

From: Sean Davis <sdavis2_at_mail.nih.gov>
Date: Wed 18 Jan 2006 - 00:31:30 EST


Why does this happen when I do a sqlQuery?

> sessionInfo()

Version 2.3.0 Under development (unstable) (2006-01-04 r36984) powerpc-apple-darwin8.3.0

attached base packages:

[1] "methods"   "stats"     "graphics"  "grDevices" "utils"     "datasets"
[7] "base"     

other attached packages:
  RODBC
"1.1-5"
> b <- sqlQuery(con,"select * from HartProbe where PROBE_ID='Hart19'")
SQLNumResultCols
SQLNumResultCols
SQLDescribeColW
SQLDescribeColW
SQLDescribeColW
SQLDescribeColW
SQLFetch
SQLFetch

I get output for each row returned. In this case, the table has a million rows, so I can't really select from it reasonably. It doesn't look to me like sqlQuery or sqlGetResults has a verbose option to turn off such output.

Thanks,
Sean



R-help@stat.math.ethz.ch mailing list
https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide! http://www.R-project.org/posting-guide.html Received on Wed Jan 18 00:43:04 2006

This archive was generated by hypermail 2.1.8 : Wed 18 Jan 2006 - 02:10:54 EST