Jerry Krinock wrote: > That's easy enough to detect with API from the OS, but a conflict can > still occur if they launch and start reading while I am in the middle > of writing something I don't want to stop. I need to lock the > database so that they get SQLITE_BUSY until I'm done. > > How can I manually lock the database using the C API? I can't find > any "lock" function.
http://www.openbsd.org/cgi-bin/man.cgi?query=flock That only works if you're on a UNIX based OS, but it's the right trick to use there. Clay _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
