dbGetQuery
comes with a default implementation that calls
dbSendQuery
, then dbFetch
, ensuring that
the result is always free-d by dbClearResult
.
dbGetQuery(conn, statement, ...)
DBIConnection
object, as produced by
dbConnect
.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.
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)
Run the code above in your browser using DataCamp Workspace