DBI (version 0.2-1)

DBIResult-class: Class DBIResult

Description

Base class for all DBMS-specific result objects.

Objects from the Class

A virtual Class: No objects may be created from it.

Extends

Class "DBIObject", directly.

Generator

The main generator is dbSendQuery.

References

See the Database Interface definition document DBI.pdf in the base directory of this package or http://developer.r-project.org/db.

See Also

DBI classes: DBIObject-class DBIDriver-class DBIConnection-class DBIResult-class

Examples

drv <- dbDriver("Oracle")
 con <- dbConnect(drv, "user/password@dbname")
 res <- dbSendQuery(con, "select * from LASERS where prdata > '2002-05-01'")
 summary(res)
 while(dbHasCompleted(res)){
    chunk <- fetch(res, n = 1000)
    process(chunk)
 }