dbFetch-Data.WorldResult-method: Get a data frame with results of a sent query.

Description Usage Arguments Value Examples

Description

Get a data frame with results of a sent query.

Usage

1
2
## S4 method for signature 'Data.WorldResult'
dbFetch(res, n = NULL, ...)

Arguments

res

a Data.WorldResult object, resulting from a call to dbSendQuery.

n

Not used. All rows are fetched.

Value

A data frame.

Examples

1
2
3
4
5
6
7
8
9
## Not run: 
conn <- dbConnect(Data.World(), 'johndoe/petstore')
old_cats_res <- dbSendQuery(conn,
                            'SELECT name, age, color
                             FROM pets
                             WHERE species=='cat' AND age > 10')
old_cats <- dbFetch(old_cats_res)

## End(Not run)

carljv/dwDBI documentation built on May 4, 2019, 7:36 a.m.