[R] Passing dynamic sql statement to RODBC functions

[Lingyun Shi]

Hi,

Does anyone know how to pass dynamic sql statement to RODBC function
"odbcQuery()" or "sqlQuery()"?
eg.: under R session, I did:
>library(RODBC)
>channel<-odbcConnect(...)
>data1<-2.5
>data2<-5.0
I want to construct the INSERT sql statement using variables "data1" and
"data2"  and pass this statement to odbcQuery() . Can I do this? what's the
syntax to construct this sql statement?

Thanks

Lingyun


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