On 24 Apr 2013, at 11:58am, "J Trahair" <j.trah...@foreversoftware.co.uk> wrote:
> I had closed the connection after the COMMIT, but it works great if I don't. Your problem is not with closing the connection but with the COMMIT. The BEGIN goes with the COMMIT. When you go 'BEGIN EXCLUSIVE' you do have your exclusive lock, but only until you have finished that transaction. And 'COMMIT' is one way to finish a transaction, so the 'COMMIT' releases the lock. So your procedure for locking a database for a quarter second is BEGIN EXCLUSIVE do anything you want here for a quarter second COMMIT You should definitely do the COMMIT eventually, of course. UNLESS you want to cancel the transaction. But closing the connection plays no part in this. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users