| 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)
}