[R] Limited output

[confusedcius]

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.