dbGetStatement {DBI} | R Documentation |
Get the statement associated with a result set
Description
Returns the statement that was passed to dbSendQuery()
or dbSendStatement()
.
Usage
dbGetStatement(res, ...)
Arguments
res |
An object inheriting from DBIResult. |
... |
Other arguments passed on to methods. |
Value
dbGetStatement()
returns a string, the query used in
either dbSendQuery()
or
dbSendStatement()
.
Failure modes
Attempting to query the statement for a result set cleared with
dbClearResult()
gives an error.
See Also
Other DBIResult generics:
DBIResult-class
,
dbBind()
,
dbClearResult()
,
dbColumnInfo()
,
dbFetch()
,
dbGetInfo()
,
dbGetRowCount()
,
dbGetRowsAffected()
,
dbHasCompleted()
,
dbIsReadOnly()
,
dbIsValid()
,
dbQuoteLiteral()
,
dbQuoteString()
Examples
con <- dbConnect(RSQLite::SQLite(), ":memory:")
dbWriteTable(con, "mtcars", mtcars)
rs <- dbSendQuery(con, "SELECT * FROM mtcars")
dbGetStatement(rs)
dbClearResult(rs)
dbDisconnect(con)
[Package DBI version 1.2.3 Index]