dbGetQuery {DBI} | R Documentation |
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.
dbGetQuery(conn, statement, ...)
conn |
A |
statement |
a character vector of length 1 containing SQL. |
... |
Other parameters passed on to methods. |
Other connection methods: dbDisconnect
;
dbExistsTable
;
dbGetException
; dbListFields
;
dbListResults
; dbListTables
;
dbReadTable
, dbWriteTable
;
dbRemoveTable
; dbSendQuery
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) }