Fetch the next
n elements (rows) from the result set and return them
as a data.frame.
## S4 method for signature 'DatabaseConnectorResult' dbFetch(res, n = -1, ...)
An object inheriting from DBIResult, created by
maximum number of records to retrieve per fetch. Use
Other arguments passed on to methods.
fetch() is provided for compatibility with older DBI clients - for all
new code you are strongly encouraged to use
dbFetch(). The default
fetch() so that it is compatible with
existing code. Modern backends should implement for
dbFetch() always returns a data.frame
with as many rows as records were fetched and as many
columns as fields in the result set,
even if the result is a single value
or has one
or zero rows.
An attempt to fetch from a closed result set raises an error.
n argument is not an atomic whole number
greater or equal to -1 or Inf, an error is raised,
but a subsequent call to
dbFetch() with proper
n argument succeeds.
dbFetch() on a result set from a data manipulation query
can be fetched and return an empty data frame, with a warning.
Close the result set with
dbClearResult() as soon as you
finish retrieving the records you want.
Other DBIResult generics:
Add the following code to your website.
For more information on customizing the embed code, read Embedding Snippets.