Skip to content
Prev 372 / 1340 Next
Original Raw

RSQLite 0.6-7 -- changes to dbGetQuery semantics

Seth Falcon 
RSQLite 0.6-7 has been uploaded to CRAN and should hit a mirror near
you in the next few days.

This version changes the behavior of the dbGetQuery method to make it
more consistent with dbSendQuery.  Specifically:

1. dbGetQuery now closes a complete result set as dbSendQuery does.

2. If there is an incomplete result set open, dbGetQuery still opens a
   new temporary connection, but now issues a warning.  It is best
   practice to explicitly close open result sets before issuing
   further queries.

These changes are in response to the following discussion on the
r-sig-db list:

    https://stat.ethz.ch/pipermail/r-sig-db/2008q1/000399.html

+ seth