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. > Moreover, if I open connections with SQLITE_OPEN_SHAREDCACHE flag, everything > works as expected. The result of shared cache is the same as if both connections are the same connection. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
