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,"select ... from tbl_n... where... ")
> bru <- fetch(cur)
> bru
This returns the first 500 of the 2192 rows of sqlite.
If I then type
> options()$max.print
I get
#[1] 99999#
And from
> str(bru)
I get
#'data.frame': 500 obs. of 2 variables:
$ vbl1 : chr...
$ vbl2 : num...#
By the way, I appreciate your help!
--
View this message in context:
http://r.789695.n4.nabble.com/Limited-output-tp2295882p2296795.html
Sent from the R help mailing list archive at Nabble.com.
______________________________________________
R-help@r-project.org mailing list
https://stat.ethz.ch/mailman/listinfo/r-help
PLEASE do read the posting guide http://www.R-project.org/posting-guide.html
and provide commented, minimal, self-contained, reproducible code.
