sqlite3_step and sqlite3_finalize don't take a sqlite3 struct, so I'm not sure how you plan to accomplish that.
if you are asking to create a prepared statement in thread A then process that statement in thread B, I havn't had problems doing that. Just make sure two threads aren't making calls on the sqlite3 struct at once. On 5/21/05, Brown, Dave <[EMAIL PROTECTED]> wrote: > > Is it ok to call sqlite3_prepare() for a statement using the sqlite3 struct > owned by thread A, and then run the actual query with sqlite3_step() and > sqlite3_finalize() using the [different] sqlite3 struct owned by thread B? > (Assume however that both sqlite3 structs were opened to the same database > file). > > -Dave > -- Cory Nelson http://www.int64.org