[R] RODBC: sqlFetch and its argument sqtable

Prof Brian D Ripley ripley at stats.ox.ac.uk
Wed Aug 28 10:09:23 CEST 2002


It's not designed to work like that.

Note that RODBC is in Devel on CRAN and not currently maintained AFAIK.

On Wed, 28 Aug 2002, RINNER Heinrich wrote:

> 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?

-- 
Brian D. Ripley,                  ripley at 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 272860 (secr)
Oxford OX1 3TG, UK                Fax:  +44 1865 272595

-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-
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