Displaying 1 result from an estimated 1 matches for "test0000853".
2009 Jan 30
1
run query using rexcel runrfile and rodbc sql query
...uot;)"
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 <- "TEST0000853"
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
(selec...