sqldf 0.4-11

[Gabor Grothendieck]

sqldf 0.4-11 is now on CRAN and should be propagating to the mirrors.  Main feature is that it should work with the new RSQLite 2.0,

[febi...@gmail.com]

On Wednesday, June 28, 2017 at 8:18:47 AM UTC-4, Gabor Grothendieck wrote:
> sqldf 0.4-11 is now on CRAN and should be propagating to the mirrors.  Main feature is that it should work with the new RSQLite 2.0,

Hi I am facing similar issue with RSQLite 2.1. Is it due to version incompatibility. I then downgraded my version of sqldf to 0.4.10 and RSQLite to 1.0.0.

Then my error is as below.
Error in sqliteSendQuery(con, statement, bind.data) :
error in statement: no such table:

My original error using latest version of RSQLite and sqldf is as below.
Error in result_create(conn@ptr, statement) :
no such table:

Any pointers on what I am doing wrong.

sqldf calls were working a month back. I haven't done any update, not sure about any automatic update though.

[Gabor Grothendieck]

You will need to show a reproducible example that use the latest version of sqldf and RSQLite on CRAN;

As far as I know select statements are working with the RSQLite backend.  Other statements work with RSQLite too but give a warning. The problem of a needless warning will have to be fixed by RSQLite -- it is not something that sqldf can easily address since it requires knowledge of the statement that is being passed which sqldf does not have.

Another thing you can do is just use a different backend.  sqldf supports 4 backends, not just sqlite; however, the other backends currently only support select statements.