[R] RODBC: sqlFetch and its argument sqtable

[RINNER Heinrich]

Calling function "sqlFetch" in library(RODBC) and specifying a character
string as 2nd argument, I get an error I don't understand:

library(RODBC)
channel <- odbcConnect("mydatabase.mdb", case="msaccess")
sqlFetch(channel, "mytable")
# this works fine
tabname <- "mytable"; sqlFetch(channel, tabname)
# this gives an error:
# Error in sqlFetch(channel, tabname) : tabname :table not found on channel
0

Shouldn't the second way work as well, or if not, why not?

platform i386-pc-mingw32
arch     i386           
os       mingw32        
system   i386, mingw32  
status                  
major    1              
minor    5.1            
year     2002           
month    06             
day      17             
language R

Package: RODBC
Version: 0.8-3
Date: 2001-06-21
-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-
r-help mailing list -- Read http://www.ci.tuwien.ac.at/~hornik/R/R-FAQ.html
Send "info", "help", or "[un]subscribe"
(in the "body", not the subject !)  To: r-help-request at stat.math.ethz.ch
_._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._