If I understand correctly, I can do this (pseudo-code):
BEGIN TRANSACTION;
// some SQL statements
BEGIN TRANSACTION;
// some more SQL statements
IF (more SQL statements == SUCCESS )
COMMIT;
END
///// no need to ROLLBACK here, it will be done in the outer transaction
IF( SQL statements == SUCCESS )
COMMIT;
ELSE
ROLLBACK;
END;
This scenario will not end up with with unfinished transaction and I
don't have to use SAVEPOINT/RELEASE in this case.
Am I correct?
Thank you.
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
