dbCommit-methods {RSQLite} | R Documentation

## DBMS Transaction Management

### Description

Not yet implemented.

### Methods

conn
  a `SQLiteConnection` object, as produced by the function `dbConnect`.
...
  any database-specific arguments.

### 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

`SQLite`, `dbConnect`, `dbSendQuery`, `dbGetQuery`, `fetch`, `dbCommit`, `dbGetInfo`, `dbReadTable`.

### Examples

    drv <- dbDriver("SQLite")
    con <- dbConnect(drv, dbname = "mySQLite.db")
    rs <- dbSendQuery(con,
          "delete * from PURGE as p where p.wavelength<0.03")
    if(dbGetInfo(rs, what = "rowsAffected") > 250){
      warning("dubious deletion -- rolling back transaction")
      dbRollback(con)
    }

[Package Contents]