dbGetQuery {DBI} | R Documentation |
dbGetQuery
comes with a default implementation that calls
dbSendQuery
, then dbFetch
, ensuring that
the result is always free-d by dbClearResult
.
dbGetQuery(conn, statement, ...)
conn |
A |
statement |
a character vector of length 1 containing SQL. |
... |
Other parameters passed on to methods. |
This function is for SELECT
queries only. Some backends may
support data manipulation statements through this function for compatibility
reasons. However callers are strongly advised to use
dbExecute
for data manipulation statements.
Subclasses should override this method only if they provide some sort of performance optimisation.
For updates: dbSendStatement
and dbExecute
.
Other DBIConnection generics: DBIConnection-class
,
dbDataType
, dbDisconnect
,
dbExecute
, dbExistsTable
,
dbGetException
, dbGetInfo
,
dbIsValid
, dbListFields
,
dbListResults
, dbListTables
,
dbReadTable
, dbRemoveTable
,
dbSendQuery
, dbSendStatement
con <- dbConnect(RSQLite::SQLite(), ":memory:") dbWriteTable(con, "mtcars", mtcars) dbGetQuery(con, "SELECT * FROM mtcars") dbDisconnect(con)