Within transaction, SQL statements after failure are still processed

When in transaction and SQL statement fails the subsequent SQL statements within that transaction are still processed. This can result in data inconsistency.

Solution: for every execute and select statement if inside a failed transaction return without doing anything.