DBI (version 0.3.0)

dbGetQuery: Send query, retrieve results and then clear result set.

Description

dbGetQuery comes with a default implementation that calls dbSendQuery, then if dbHasCompleted is TRUE, it uses fetch to return the results. on.exit is used to ensure the result set is always freed by dbClearResult. Subclasses should override this method only if they provide some sort of performance optimisation.

Usage

dbGetQuery(conn, statement, ...)

Arguments

conn

A DBIConnection object, as produced by dbConnect.

statement

a character vector of length 1 containing SQL.

...

Other parameters passed on to methods.

See Also

Other connection methods: dbDisconnect; dbExistsTable; dbGetException; dbListFields; dbListResults; dbListTables; dbReadTable, dbWriteTable; dbRemoveTable; dbSendQuery

Examples

if (require("RSQLite")) {
con <- dbConnect(RSQLite::SQLite(), ":memory:")

dbWriteTable(con, "mtcars", mtcars)
res <- dbSendQuery(con, "SELECT * FROM mtcars WHERE cyl = 4;")
dbFetch(res)
dbClearResult(res)

dbDisconnect(con)
}

Run the code above in your browser using DataCamp Workspace