RODBCDBI (version 0.1.1)

odbc-meta: Database interface meta-data.

Description

See documentation of generics for more details.

Usage

"dbGetRowCount"(res, ...)
"dbGetStatement"(res, ...)
"dbGetInfo"(dbObj, ...)
"dbColumnInfo"(res, ...)

Arguments

res

An object of class ODBCResult

...

Ignored. Needed for compatibility with generic

dbObj

An object inheriting from ODBCConnection, ODBCDriver, or a ODBCResult

Examples

## Not run: 
# library(DBI)
# data(USArrests)
# con <- dbConnect(RODBCDBI::ODBC(), dsn="test", user="sa", password="Password12!")
# dbWriteTable(con, "t1", USArrests, overwrite=TRUE)
# dbWriteTable(con, "t2", USArrests, overwrite=TRUE)
# 
# dbListTables(con)
# 
# rs <- dbSendQuery(con, "select * from t1 where UrbanPop >= 80")
# dbGetStatement(rs)
# dbHasCompleted(rs)
# 
# info <- dbGetInfo(rs)
# names(info)
# info$fields
# 
# dbFetch(rs, n=2)
# dbHasCompleted(rs)
# info <- dbGetInfo(rs)
# info$fields
# dbClearResult(rs)
# 
# # DBIConnection info
# names(dbGetInfo(con))
# 
# dbDisconnect(con)
# ## End(Not run)