SQLite Forum

Two points:

- Please do not piggy-back on other unrelated threads, start a new one for a new question.
- This is not an SQLite question but I assume a "DB Browser for SQLite" question, which should get you best results when posting it to that system's forum/list.

That said, my guess would be that the Browser you use might automagically keep an already-opened transaction for you (as is the habit of some such browsers), so perhaps you can dispense with opening the transaction and just commit it when needed.

If you are testing a script that should run by itself, and you need to include the Starting and ending of transactions, perhaps make that in a file that can be run through sqlite3.exe, or, you know, use sqlite studio or another browser that works the way you prefer, or ask the DB Browser folks if a setting can perhaps change that behavior.