Hello R users,
I would like to use an integer and a date as attributes in sqlQuery,
and these arguments are defined in my function.
Here is my function:
GetReturn<-function(code,date)
{
channel<-odbcConnect("db","user1","password")
ssql<-paste("select * from TABLE Where PF_CODE =",code,"and
PF_DATE=",date)
mydata<-sqlQuery(channel,ssql)
mydata
}
Actually, the channel is open but the query on the table did not work.
The command paste worked for the integer argument but not for the date.
Thank you for helping.
A.Many