Hello. I getinng an error in a following scenario. I think such a behaviour is not obvoius. 1. Enable shared cache 2. Open db with SQLITE_OPEN_READONLY 3. Open same db again with SQLITE_OPEN_READWRITE 3.1 Try to insert for last connection. = You get SQLITE_READONLY error. If swap 2 and 3 steps, when all works without errors.
Code example: http://pastebin.com/ubg0mBrN Output: insert - 8 I can't find any mention of such a behaviour in documentation. So I think it is bug in implementation or in documentation. I have been working on a large enterprise application and when someone enabled shared cache globally, investigation for READONLY error in my code took a lot of time. Regards, Yuri Krivopalov _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
