Zbigniew Baniewski <[EMAIL PROTECTED]> wrote: > On Sun, Sep 16, 2007 at 08:42:44PM -0700, Joe Wilson wrote: > > > Host a shared database file on computer A, say shared.db. > > >From computer B, open shared.db remotely and execute "BEGIN EXCLUSIVE;". > > >From computer C, open shared.db remotely and execute "BEGIN EXCLUSIVE;". > > If computer C has the error "SQL error: database is locked", then > > its locking probably works. > > BTW: I'm wondering, if there's a possibility to set in similar manner > exclusive rights to access the database file for the duration of the entire > "database session", not just transaction. I mean: when I'm using a program > which is accessing the database - nobody else has access.
http://www.sqlite.org/pragma.html#pragma_locking_mode -- D. Richard Hipp <[EMAIL PROTECTED]> ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
