Hello all, is there a way to query if the database file is currently locked ?
Background: My application may run for weeks (hopefully) and uses EXCLUSIVE transactions in some threads. On a daily basis I would like to copy the database file for backup purpose. I assume that this will fail when there is an exclusive transaction ongoing. It would be more elegant to ask sqlite rather than test against a FileCopy failure. I found the "PRAGMA locking_mode" statement, is this the one to use ? Thank you Marcus _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
