Yes, a BEGIN EXCLUSIVE does lock it, but then as soon as I do some other SQL, it automatically UN LOCKS the db unfortunately. I need to keep it locked until I unlock it.
Will Leshner <[EMAIL PROTECTED]> wrote on 06/17/2005 01:47:08 PM: > > On Jun 17, 2005, at 9:57 AM, de f wrote: > > > The > > automatic > > locking of Transactions in sqlite does not give me direct > > control and is of no > > use to me (those locks go away automatically, leaving me no > > control over them.) > > > > > Are you sure? Have you investigated BEGIN EXCLUSIVE?
