Hi all, I wrote a piece of code, that open two sqlite3 connections, use connection1 to do a SELECT query, while stepping in this query,
when some condition matches, it uses connection2 to do a INSERT query; when another condition matches, it uses connection2 to do a UPDATE query. As common result, SQLITE_BUSY or SQLITE_LOCKED(when using SQLITE_OPEN_SHAREDCACHE) will return when do INSERT or UPDATE. I understand that, commonly, INSERT or UPDATE need to request a EXCLUSIVE lock but SELECT holds the SHARED lock. I want to know if there is any flags/options/modes that can enable me to do that ? -- Regards, Fengtao _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
