[sqlite] I don't understand why I get "cannot start a transaction within a transaction"

[Simon Slavin]

On 31 Aug 2015, at 2:23pm, Stephan Beal <sgbeal at googlemail.com> wrote:

> Nope - you have only run the BEGIN part of the transaction. prepare()
> prepares only one single statement, not multiples (you have 4 statements in
> your SQL). Thus when you try to run another transaction, that BEGIN is
> still open.

In contrast sqlite_exec() can process multiple statements, the way you were 
trying to use _prepare(),_step(),_finalize().

<https://www.sqlite.org/c3ref/exec.html>

"run multiple statements of SQL without having to use a lot of C code."

Simon.