On Thu, Jun 2, 2016 at 1:51 AM, Simon Slavin <slav...@bigfraud.org> wrote:
> > On 1 Jun 2016, at 4:15pm, Gelin Yan <dynami...@gmail.com> wrote: > > > In Process A > > > > insert a value into a table XX and commit. > > > > In Process B > > > > select from the same table XX > > > > and I didn't find the inserted record. > > Did you do process A by explicitly declaring BEGIN or did you let SQLite > make its own transaction ? > > Did you do all of A before you started B ? > > Are you using exec() or prepare(), step(), finalize() ? > > Simon. > _______________________________________________ > sqlite-users mailing list > sqlite-users@mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > Hi All After I added conn.execute("BEGIN") and conn.execute("COMMIT") in Process B, I can see the inserted record. It makes sense now. I would appreciate it if your guys can tell me the reason. Regards gelin yan _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
