On 10/06/2009 4:40 AM, Jeremy Smith wrote:
> When I run sqlite3_interrupt, it doesn't close existing file handles, 
> making further searches tricky.

Which handles? How do you know? What does "tricky" mean -- "difficult 
but I can cope with it" or "causes an error" (if so, which?) or 
something else?

> So I wrote code which clears all normal 
> file handles (fopen in shell.c), but...

Have you tried calling sqlite3_finalize() on each prepared statement and 
sqlite3_close() on each open connection?


> How do I close the database file too? It's not opened using fopen, but 
> with CreateFileA (in winOpen in os_win.c) so I don't know what to call 
> after calling sqlite3_interrupt. CloseHandle(global_h) just throws up an 
> error. And I can't do further searches until the database file is free.

_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to