On 9 May 2012 10:33, <ext-esko.huja...@elektrobit.com> wrote: > Hi All, > > 1: SAVEPOINT 1 > 2: insert A > 3: RELEASE SAVEPOINT 1 > 4: SAVEPOINT 2 > 5: insert B > 6: ROLLBACK TO SAVEPOINT 2 > > ROLLBACK in line 6 cancels also line 2 in addition to line 5. > > I want to cancel just line 5. > > What am I doing wrong ? > > br, > > Esko
On Win7 32 bit: SQLite version 3.7.10 2012-01-16 13:28:40 Enter ".help" for instructions Enter SQL statements terminated with a ";" sqlite> sqlite> create table t( id integer primary key, data text ); sqlite> savepoint a; sqlite> insert into t( data ) values( '1' ); sqlite> release savepoint a; sqlite> savepoint b; sqlite> insert into t( data ) values( '2' ); sqlite> rollback to savepoint b; sqlite> select * from t; 1|1 sqlite> sqlite> commit; sqlite> select * from t; 1|1 sqlite> I see no problem. Perhaps you can expand on the environment/version in which you are trying this Regards, Simon _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users