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]>