| dbCommit-methods {RSQLite} | R Documentation |
Not yet implemented.
SQLiteConnection object, as produced by the function
dbConnect.
See the Database Interface definition document
DBI.pdf in the base directory of this package
or
http://stat.bell-labs.com/RS-DBI.
SQLite,
dbConnect,
dbSendQuery,
dbGetQuery,
fetch,
dbCommit,
dbGetInfo,
dbReadTable.
## Not run:
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)
}
## End(Not run)