From Urlich's explanation (I respect him as he is in the 'game of programming ' many years ahead me) is this, I quote: ---------------------------------- This decreases the chance of failure but doesn't eliminate it, since still SQLite handles are passed around. As soon as the database thread accesses the database independently in parallel to the thread consuming the result set this could result in problems. -----------------------------------
So what advice do you give me in such need that are thread safe? Any other approach? On 02/03/2011 03:09 PM, Pavel Ivanov wrote: > What problems did you meet when you tried to do what you want? > > > Pavel > > On Thu, Feb 3, 2011 at 4:39 AM, Stefano Mtangoo<[email protected]> wrote: >> Hi, >> I use SQLite3 with wxSQLite3 wrapper and all is fine until I wanted to >> shift the DB thing into the secondary thread. >> What I want to do is send string containing query to secondary thread >> and the secondary thread is supposed to query db and post back the >> resultset. >> Urlich had doubts about the approach and full posts is here: >> http://forum.wxwidgets.org/viewtopic.php?t=29991 >> >> >> How can I do that with SQLite3? No access to database at the same time. >> With thanks, >> Stefano >> >> -- >> _________________________________________________________________________ >> The purpose of man is to know his Maker Be known by his Maker And make his >> Maker known So that others may know his Maker as their Maker(Emeal Zwayne) >> >> _______________________________________________ >> sqlite-users mailing list >> [email protected] >> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users >> > _______________________________________________ > sqlite-users mailing list > [email protected] > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users -- _________________________________________________________________________ The purpose of man is to know his Maker Be known by his Maker And make his Maker known So that others may know his Maker as their Maker(Emeal Zwayne) _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
