Displaying 1 result from an estimated 1 matches for "expr1000".
2009 Sep 21
1
RODBC : using and passing queries that use " in some arguments
...struction 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 Colonne_3 ")
> Col3<-sqlQuery(con, query=MyQuery)
> Col3
Expr1000 Cond
1 23/06/2009 10:15:02 579.9562...