Displaying 1 result from an estimated 1 matches for "odbcobj".
2006 Oct 05
2
Variables in RODBC environment
Hello Experts,
how can I use variables in the RODBC environment.
Example which does not work:
Thanks for your help.
Thorsten
pn <- '39R5238';
library(RODBC);
odbcobj <- odbcConnect("SQUIT21C",uid="muehge",pwd="xxx");
sql <- "select
u.unitid,
from test
where part in ('pn')
";
parameter <- sqlQuery(odbcobj,sql);
odbcClose(odbcobj);