RSQLite (version 1.0.0)

sqlite-meta: Database interface meta-data.

Description

See documentation of generics for more details.

Usage

# S4 method for SQLiteResult
dbColumnInfo(res, ...)
# S4 method for SQLiteResult
dbGetRowsAffected(res, ...)
# S4 method for SQLiteResult
dbGetRowCount(res, ...)
# S4 method for SQLiteResult
dbHasCompleted(res, ...)
# S4 method for SQLiteResult
dbGetStatement(res, ...)

Arguments

res

An object of class '>SQLiteResult

...

Ignored. Needed for compatibility with generic

Examples

# NOT RUN {
data(USArrests)
con <- dbConnect(SQLite(), dbname=":memory:")
dbWriteTable(con, "t1", USArrests)
dbWriteTable(con, "t2", USArrests)

dbListTables(con)

rs <- dbSendQuery(con, "select * from t1 where UrbanPop >= 80")
dbGetStatement(rs)
dbHasCompleted(rs)

info <- dbGetInfo(rs)
names(info)
info$fields

fetch(rs, n=2)
dbHasCompleted(rs)
info <- dbGetInfo(rs)
info$fields
dbClearResult(rs)

# DBIConnection info
names(dbGetInfo(con))

dbDisconnect(con)
# }