Message-ID: <Pine.GSO.4.44.0208280907530.4849-100000@auk.stats>
Date: 2002-08-28T08:09:23Z
From: Brian Ripley
Subject: RODBC: sqlFetch and its argument sqtable
In-Reply-To: <C4D44AB4CB62D311BA6500041202E886031EE10A@xms1.tirol.gv.at>
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
_._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._