Hi, Statements will be in progress until you issue an sqlite_reset or sqlite_finalize on them.
I don't know why rollback doesn't take care of this; perhaps someone will explain, Rgds, Simon On 23/11/2007, ??????? ???????? <[EMAIL PROTECTED]> wrote: > Hi all... > > Explain me something please. Consider scenario: > > Connection 1: begin > Connection 1: update... > Connection 2: begin > Connection 2: update... -> SQLITE_BUSY > Connection 2: rollback -> "cannot rollback transaction - SQL > statements in progress" > > Why didn't rollback work? > How can I cancel the transaction in connection 2? > > P.S. I use SQLite 3.5.1. > I have read documentation for BEGIN-ROLLBACK and ON CONFLICT. > > > > > > > ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------