Displaying 1 result from an estimated 1 matches for "dateheure".
2009 Sep 21
1
RODBC : using and passing queries that use " in some arguments
Dear R users,
I am trying to connect R to data that is in a Access Database but I have problem with the construction of queries using special characters.
I am using RODBC package.
The following is working :
> MyQuery<-paste("SELECT first( (DateHeure) ) , avg(NNO3_AT322_OUT_moy) AS Cond FROM Colonne_3 ")
> Col3<-sqlQuery(con, query=MyQuery)
> Col3
Expr1000 Cond
1 2009-06-23 10:15:02 579.9562
>
> MyQuery<-paste("SELECT first( format (DateHeure) ) , avg(NNO3_AT322_OUT_moy) AS Cond FROM...