[R] Problem with SQLDF - Error in sqliteExecStatement(con, statement, bind.data) : RS-DBI driver: (error in statement: no such table:

Gabor Grothendieck ggrothendieck at gmail.com
Thu May 10 01:52:06 CEST 2012


On Wed, May 9, 2012 at 7:24 PM, Shivam <shivamsingh at gmail.com> wrote:
> Ohh ... Thanks Gabor. I have a few related queries then, kindly have a look:
>
> 1. Does it only hinder the sqldf package or are there other issues with
> using POSIXlt in a dataframe? Am asking because I have a few dataframes with
> columns of class(POSIXlt ).
>
> 2. I have columns containing 'date+timestamp', something like '2011-01-03
> 09:07:07' which are of class POSIXlt. I need to perform some arithmetic
> operations on these columns. Which class would be most appropriate for such
> kind of data?
>

Its not just sqldf.  You will have other problems too if you put
POSIXlt objects in data frames too.

See R News 4/1.

-- 
Statistics & Software Consulting
GKX Group, GKX Associates Inc.
tel: 1-877-GKX-GROUP
email: ggrothendieck at gmail.com



More information about the R-help mailing list