SQLite Forum

Nesting of statements
Login
Sorry -  yes it is just example code to illustrate the nesting of an update within a select, which for reasons of the application logic, is hard to avoid.

You are right about there always being a transaction.