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