1. Please subscribe to the rcom mailing list,
and pose your question there.
RExcel questions should not be posed on r-help.
2. You have a trivial typo in your code,
you define inSet and then you use inSET.
When code does not run in RExcel, please test the same code in R.
You code will not run in R.
BrianCBolt wrote:
Hi,
I'm using R-2.8.1 for windows. I wrote a script calls the RODBC package
to run sql queries against an oracle database. It runs fine when run
from the rconsole and returns a data.frame with a summary for a set of
experiments. I want to run this script using the rinterface.RunRFile
command in an excel plugin, using the rexcel package. When I run the
code from my excel plugin I get an error: Error -2147220502 in Module
RExcel.RServer Error running expression
eval(parse(text=source(.rexcel..hzpouai)))
Here is my excel plugin code:
rinterface.StartRServer
rinterface.RRun setwd(C:/Documents and Settings/bbolt/Desktop)
ChDir C:/Documents and Settings/bbolt/Desktop
rinterface.RunRFile Script.r
It works fine if Script.r is something simple like:
Text - data.frame(Hello=Hello)
But will give me the error when Script.R is something like:
inSet - TEST853
library(RODBC)
query - function(qu){
con -
odbcConnect(Development,uid=username,pwd=password,believeNRows=FALSE,rows_at_time=50)
sqlQuery(con,qu)
}
qu - paste(m.parentid as SET from setmap m where m.childid in (select
t.experiment from experimentsets t where t.setname=',inSET,'),sep=)
ExperimentSet - as.character(query(qu)[,1])
The error only occurs when I call my query function. Does anyone know
if there is a way to run sql queries in this manner?
__
R-help@r-project.org mailing list
https://stat.ethz.ch/mailman/listinfo/r-help
PLEASE do read the posting guide
http://www.R-project.org/posting-guide.html
and provide commented, minimal, self-contained, reproducible code.
No virus found in this incoming message.
Checked by AVG - http://www.avg.com
Version: 8.0.176 / Virus Database: 270.10.15/1924 - Release Date: 1/29/2009
5:57 PM
--
Erich Neuwirth, University of Vienna
Faculty of Computer Science
Computer Supported Didactics Working Group
Visit our SunSITE at http://sunsite.univie.ac.at
Phone: +43-1-4277-39464 Fax: +43-1-4277-39459
__
R-help@r-project.org mailing list
https://stat.ethz.ch/mailman/listinfo/r-help
PLEASE do read the posting guide http://www.R-project.org/posting-guide.html
and provide commented, minimal, self-contained, reproducible code.