> On Nov 20, 2018, at 10:27 AM, Simon Slavin <slav...@bigfraud.org> wrote: > On 20 Nov 2018, at 3:34pm, Albert Banaszkiewicz > <albert.banaszkiew...@tomtom.com> wrote: > >> ExecuteInTransaction(writeDb1, KCreateTable); > > I can't answer your question but the above line shows a misunderstanding of > SQL. Transactions are for commands which modify tables: INSERT, UPDATE, > DELETE. Commands which modify the database schema fall outside the scope of > transactions and cannot be handled within the framework of COMMIT and > ROLLBACK. > > So don't use BEGIN and COMMIT for anything except INSERT, UPDATE, DELETE . > Perhaps you could make that change to your code and see whether the problem > remains.
While that is true in many RDBMS products, in SQLite DDL commands are transactional. -j _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users