[R] problems with RODBC, sqlQuery

JoK LoQ jokloq at gmail.com
Thu Aug 20 19:49:10 CEST 2009


Im trying to get a Oracle database to R, but I'm having problems with most
of SQL sintax. Suppose that Im trying to bring a table "TABLE" with columns
"COL1","COL2",.. from schema "SCHEMA". What am I doing wrong?

sqlQuery(channel, "select * from SCHEMA.TABLE")
[it works fine]
sqlQuery(channel, "select * from SCHEMA.TABLE where COL1>10")
[""[RODBC] ERROR: Could not SQLExecDirect"
[" (...) :invalid table name"]

View this message in context: http://www.nabble.com/problems-with-RODBC%2C-sqlQuery-tp25066803p25066803.html
Sent from the R help mailing list archive at Nabble.com.

More information about the R-help mailing list