SQLiteResult-class {RSQLite} | R Documentation

## Class SQLiteResult

### Description

SQLite's query results class. This classes encapsulates the result of an SQL statement (either `select` or not).

### Generators

The main generator is `dbSendQuery`.

### Extends

Class `"DBIResult"`, directly. Class `"SQLiteObject"`, directly. Class `"DBIObject"`, by class "DBIResult". Class `"dbObjectId"`, by class "SQLiteObject".

### Methods

coerce
  `signature(from = "SQLiteConnection", to = "SQLiteResult")`: ...
dbClearResult
  `signature(res = "SQLiteResult")`: ...
dbColumnInfo
  `signature(res = "SQLiteResult")`: ...
dbGetException
  `signature(conn = "SQLiteResult")`: ...
dbGetInfo
  `signature(dbObj = "SQLiteResult")`: ...
dbGetRowCount
  `signature(res = "SQLiteResult")`: ...
dbGetRowsAffected
  `signature(res = "SQLiteResult")`: ...
dbGetStatement
  `signature(res = "SQLiteResult")`: ...
dbHasCompleted
  `signature(res = "SQLiteResult")`: ...
dbListFields
  `signature(conn = "SQLiteResult", name = "missing")`: ...
fetch
  `signature(res = "SQLiteResult", n = "numeric")`: ...
fetch
  `signature(res = "SQLiteResult", n = "missing")`: ...
summary
  `signature(object = "SQLiteResult")`: ...

### Author(s)

R-SIG-DB

### 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: `SQLiteObject-class` `SQLiteDriver-class` `SQLiteConnection-class` `SQLiteResult-class`

### Examples

    drv <- dbDriver("SQLite")
    con <- dbConnect(drv, dbname = "rsdbi.db")

[Package Contents]