Displaying 2 results from an estimated 2 matches for "week33".
Did you mean:
week3
2012 Nov 06
0
How to read all table in r using dbreadTable, autimatically read in whenever I save new table in SQLite db
HI,
I got the problem.
I use the following query to read table individually, how can I read all tables autimatically rather than typing "week42" "week33" in dbReadTable?
library(RSQLite)
library(sqldf)
drv <- dbDriver("SQLite")
con<-dbConnect(drv, "sqlite.db")
dbListTables(con)
#dbRemoveTable(con, "week39")
dbDisconnect(con)
week42<- dbReadTable(con, "week_42")
week33<- dbReadTable(con,...
2012 Nov 02
1
can not read table in dbReadTable
> tbs<-dbListTables(con)
>
> tbs
[1] "lowend" "time" "week30" "week33" "week39" "week42"
> my.data.copy <- dbReadTable(tbs, "week42")
Error in function (classes, fdef, mtable) :
unable to find an inherited method for function "dbReadTable", for signature "character", "character"
I have creat...