[R] sqldf problems

[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 [1] (including a test data set) as the Posting Guide requests.

NB I don't have Windows 8 or 8.1, so if that turns out to be the problem then I won't be able to tell, but I have a feeling there is something more basic going on here.

[1] http://stackoverflow.com/questions/5963269/how-to-make-a-great-r-reproducible-example
---------------------------------------------------------------------------
Jeff Newmiller                        The     .....       .....  Go Live...
DCN:<jdnewmil at dcn.davis.ca.us>        Basics: ##.#.       ##.#.  Live Go...
                                      Live:   OO#.. Dead: OO#..  Playing
Research Engineer (Solar/Batteries            O.O#.       #.O#.  with
/Software/Embedded Controllers)               .OO#.       .OO#.  rocks...1k
--------------------------------------------------------------------------- 
Sent from my phone. Please excuse my brevity.

On July 14, 2014 4:52:18 AM PDT, "Juan Daniel García" <juandaniel.gv at gmail.com> wrote:
>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
>
>Thanks