On Thu, 2005-03-31 at 17:08 -0500, Kervin L. Pierre wrote:
> Are there plans for supporting nested transactions
> in the future?
No.
> The current restriction makes it hard to use SQLite
> in developing a API eg....
>
> exposed_func1(){
> sqlite3_exec("BEGIN");
> [...do stuff...]
> func2();
> sqlite3_exec("END");
> }
>
> exposed_func2(){
> sqlite3_exec("BEGIN");
> [...do stuff...]
> sqlite3_exec("END");
> [...do more stuff...]
> }
>
Instead of calling sqlite3_exec("BEGIN") and sqlite3_exec("END")
directly, put them in a wrapper function that counts the number
of nested invocations. Only execute the SQL at the top level.
--
D. Richard Hipp <[EMAIL PROTECTED]>
