dbGetRowCount {DBI} | R Documentation |
This value is increased by calls to dbFetch
. For a data
modifying query, the return value is 0.
dbGetRowCount(res, ...)
res |
An object inheriting from |
... |
Other arguments passed on to methods. |
a numeric vector of length 1
Other DBIResult generics: DBIResult-class
,
SQL
, dbBind
,
dbClearResult
, dbColumnInfo
,
dbFetch
, dbGetInfo
,
dbGetRowsAffected
,
dbGetStatement
,
dbHasCompleted
, dbIsValid
con <- dbConnect(RSQLite::SQLite(), ":memory:") dbWriteTable(con, "mtcars", mtcars) rs <- dbSendQuery(con, "SELECT * FROM mtcars") dbGetRowCount(rs) ret1 <- dbFetch(rs, 10) dbGetRowCount(rs) ret2 <- dbFetch(rs) dbGetRowCount(rs) nrow(ret1) + nrow(ret2) dbClearResult(rs) dbDisconnect(con)