It didn't work correctly because the sequence of commands you sent doesn't make sense.
BEGIN; ... RELEASE point1; ... ROLLBACK; ... END; First you began an explicit transaction. Then you tried to release a savepoint that you never created. (Hence the "no such savepoint" error message.) Then you rolled back the explicit transaction. Then you tried to end (i.e., commit) the explicit transaction, but you already rolled back, so this is invalid. (Hence the "no transaction is active" error message.) I'm not quite sure what you were trying to do. It appears you want a nested transaction, which can only be accomplished with savepoints. -- Sent from: http://sqlite.1065341.n5.nabble.com/ _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users