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
.
## Don't 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 Don't run