On 5/24/2012 9:06 PM, Igor Tandetnik wrote:
On 5/24/2012 8:55 PM, Andrew Cherednik wrote:
The program is a multi-user program that runs across the network in
Windows environment. The users constantly experience database lockout
problems. I suspect that it is due to the fact that the sqlite* object
that has been used for database updates still remains in the
'exclusive lock' mode even when the program is doing normal 'selects'.
It that's what happens, it likely means you are forgetting to
sqlite3_reset or sqlite3_finalize prepared statements after executing them.
Actually, scratch that. Multiple statements running on the same
connection will never lock each other out. Are multiple instances of
your application running at the same time, connecting to the same database?
What exactly do you mean by "database lockout problems"? What error in
what API call are you getting?
--
Igor Tandetnik
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
