\Header{dbCommit-methods}{DBMS Transaction Management}
\alias{dbCommit,SQLiteConnection-method}{dbCommit-methods}
\alias{dbRollback,SQLiteConnection-method}{dbCommit-methods}
\alias{dbRollback-methods}{dbCommit-methods}
\keyword{interface}{dbCommit-methods}
\keyword{interface}{dbCommit-methods}
\keyword{database}{dbCommit-methods}
\begin{Description}\relax
Not yet implemented.\end{Description}
\begin{Section}{Methods}
\describe{
\item[conn] a \code{SQLiteConnection} object, as produced by the function 
\code{dbConnect}.

\item[\dots ] any database-specific arguments.

}\end{Section}
\begin{References}\relax
See the Database Interface definition document
\code{DBI.pdf} in the base directory of this package
or
\url{http://developer.r-project.org/db}.\end{References}
\begin{SeeAlso}\relax
\code{\Link{SQLite}},
\code{\Link{dbConnect}},
\code{\Link{dbSendQuery}},
\code{\Link{dbGetQuery}},
\code{\Link{fetch}},
\code{\Link{dbCommit}},
\code{\Link{dbGetInfo}},
\code{\Link{dbReadTable}}.\end{SeeAlso}
\begin{Examples}
\begin{ExampleCode}
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{ExampleCode}
\end{Examples}

