2014-07-14 7:52 GMT-04:00 Juan Daniel García <juandaniel...@gmail.com>: > Hello: > I'm trying to run this code > > data2 <- sqldf (" SELECT plot, age, avg(N) as N FROM data1 GROUP BY plot, > t") > > The problem is that when calling sqldf with >>require(sqldf) > > appears this message > > Warning message: > In sqliteCloseConnection(conn, ...) : > RS-DBI driver warning: (closing pending result sets before closing this > connection) > > If try again > >>require(sqldf) > > the message does not appear, but when trying the code afterwards, I get a > new message > > Error in sqliteFetch(rs, n = -1, ...) : > RSQLite driver: (RS_SQLite_fetch: failed: Domain error) > > I have a new Windows 8.1 > > Do I need any other installations o packages or something else? > The code was working in older Windows XP and Linux >
See the Troubleshooting section of the sqldf home page. http://sqldf.googlecode.com ______________________________________________ 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.