[R] sqldf problems

2014-07-14 Thread Juan Daniel García
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

Re: [R] sqldf problems

2014-07-14 Thread Gabor Grothendieck
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

Re: [R] sqldf problems

2014-07-14 Thread Jeff Newmiller
One doesn't call a package... so your description is unclear. One doesn't load (using the require or library functions) the relevant package AFTER calling functions in the package. Since it appears you have left out some steps or described them out of order, please supply a reproducible example