SQLITE and implicit transaction

Hi all,

With SQLITE, WAL mode (multiuser).

The SQLITE documentation says:

In Xojo, a method that contains two SQL methods without explicit transaction, such as:


will be considered a single transaction (BEGIN - SELECT - SELECT - COMMIT) or two transactions (BEGIN - SELECT - COMMIT - BEGIN - SELECT - COMMIT) by SQLITE?

Thank you


If you’re not using a BEGIN then everything is an implicit transaction.

Everything in between a Begin and Commit is the same transaction so both of your examples would be a single transaction.