dbGetQuery
From DBI v0.3.0
by Hadley Wickham
Send query, retrieve results and then clear result set.
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 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)
}Community examples
Looks like there are no examples yet.