[sqlite] Fw: Fw: Is there a command to lock a database for a short while (0.25 sec, say)

2013-04-24 Thread J Trahair
I've found that either one of these will lock the database: mstrSQL = PRAGMA locking_mode = EXCLUSIVE;BEGIN EXCLUSIVE; mstrSQL = PRAGMA locking_mode = EXCLUSIVE;BEGIN EXCLUSIVE;COMMIT; and that closing the connection a little while later (eg. 0.25sec)

Re: [sqlite] Fw: Fw: Is there a command to lock a database for a short while (0.25 sec, say)

2013-04-24 Thread Eduardo Morras
On Wed, 24 Apr 2013 16:35:21 +0200 J Trahair j.trah...@foreversoftware.co.uk wrote: I've found that either one of these will lock the database: mstrSQL = PRAGMA locking_mode = EXCLUSIVE;BEGIN EXCLUSIVE; mstrSQL = PRAGMA locking_mode = EXCLUSIVE;BEGIN