[R] RODBC: sqlFetch and its argument sqtable

RINNER Heinrich H.RINNER at tirol.gv.at
Wed Aug 28 09:48:39 CEST 2002

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

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

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

platform i386-pc-mingw32
arch     i386           
os       mingw32        
system   i386, mingw32  
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

More information about the R-help mailing list