Hello, using RJDBC within R and successful at fetching and writing
data, one quick question that I can't find an answer to:
Running a drop table and create table query, they run and they work, but
R returns a error. I am using dbSendQuery - i thought dbSend just
submits SQL and does not expect a result set - does anyone know how to
avoid the error? It should be a warning not an error i think - as the
commands are working on the database.
dbSendQuery(conn,"DROP TABLE loyalty")
Error in .verify.JDBC.result(r, "Unable to retrieve JDBC result set for
", :
Unable to retrieve JDBC result set for DROP TABLE loyalty (No results
were returned by the query.)
dbSendQuery(conn,"CREATE TABLE loyalty (ID varchar(30))")
Error in .verify.JDBC.result(r, "Unable to retrieve JDBC result set for
", :
Unable to retrieve JDBC result set for CREATE TABLE loyalty (ID
varchar(30)) (No results were returned by the query.)
[[alternative HTML version deleted]]
______________________________________________
R-help@r-project.org mailing list
https://stat.ethz.ch/mailman/listinfo/r-help
PLEASE do read the posting guide http://www.R-project.org/posting-guide.html
and provide commented, minimal, self-contained, reproducible code.
