I just found the solution...
I used dbGetQuery instead of dbSendQuery. That's a more direct approach and
it works. Thanks again for your help.
--
View this message in context:
http://r.789695.n4.nabble.com/Limited-output-tp2295882p2296822.html
Sent from the R help mailing list archive at Nabble.
The details of my problem are as follows:
I have an sql that returns 2192 rows in sqlite.
In R, I typed the following:
> library("RSQLite")
> con <- dbConnect(dbDriver("SQLite"), dbname = "C:\\sqlite\\... .sqlite")
> dbListTables(con)
#[1] "tbl_n..." "tbl_s..."#
> cur <- dbSendQuery(con,"sele
Hi there,
I entered over 2000 lines of data into R from SQLite and saved it in R as a
data.frame, but the data.frame only gives the first 500 lines. Is there any
way to either increase the default limit or to determine which of the
original lines should be in the output (e.g. maybe the last 500 i
3 matches
Mail list logo