Simple question, but cannot find the answer.
Instead of:
Df <- sqlQuery(ch, "SELECT * FROM tblTest WHERE Id=25")
I want a more dynamic piece of code. Something like:
Id <- 25
Df <- sqlQuery(ch, c("SELECT * FROM tblTest WHERE Id=", Id))
But this is not correct.
We can use paste:
Df <- sqlQuery(ch, paste("SELECT * FROM tblTest WHERE Id =", Id))
c
concatenates into a vector, paste
is for string concatenation.
Or we can use sprintf:
sprintf("SELECT * FROM tblTest WHERE Id = %s", Id)