SQLITE and implicit transaction

[olivierV]

Hi all,

With SQLITE, WAL mode (multiuser).

The SQLITE documentation says:

An implicit transaction (a transaction that is started automatically, not a transaction started by BEGIN) is committed automatically when the last active statement finishes. A statement finishes when its prepared statement is reset or finalized.

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

• SELECT…
• SELECT…

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

Thank you

olivier

[Bob_Keeney]

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.