[R] sqldf problems

[Gabor Grothendieck]

2014-07-14 7:52 GMT-04:00 Juan Daniel García <juandaniel.gv at 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