> A need little trick is to explicitly state “begin transaction “ and “end transaction” in my app.

That is exactly what the parent comment already said:

> if you do them in one transaction

The commands you stated are exactly how to do (multiple) things in a transaction.