Selecting only 500 rows from table in R

Question

I am using RSQLite package for database operations. For selecting data from table, I used the following code, but I got only 500 rows. Actually this table contains 1200+ rows for that query. What is the cause of this problem?

library('RSQLite')
lite <- dbDriver("SQLite", max.con = 25)
db <- dbConnect(lite, dbname = "pf.db")
res <- dbSendQuery(db, paste("SELECT ticker from RUS1000 where portDate='1995-12-29'  ",sep=""))
data <- fetch(res)
print(data)

Can you post the file so we can try to replicate the problem? — nograpes, Apr 11 '13 at 18:04

score 3 · Accepted Answer · answered Apr 11 '13 at 18:13

3

Try data <- fetch(res,n=-1). This will fetch all rows.

answered Apr 11 '13 at 18:13

imran

1,560
10
8

score 3 · Answer 2 · answered Apr 11 '13 at 18:24

3

or try the easy way

data <- dbGetQuery.....

answered Apr 11 '13 at 18:24

Dieter Menne

10,076
44
67

Selecting only 500 rows from table in R

2 Answers2