1) Sqlite database file access restriction: Is there a built-in or
preferred method to block other processes from writing or even
accessing
a database file when its opened first by another process. I can
get this
to work by having the first process to open the file issue a BEGIN
Exclusion or BEGIN Restricted but there is always a chance, that
right
after I commit and go to issue another BEGIN, a 2^nd progress can
grab
and hold the file. I would like for the 2^nd process to see if
another
process has control of the file and warn/adapt based on that.
Definitely
NO multiple writers.
That is Absolutely the only way get that kind of 'useful' lock on
windows.
End of story!
There is a pragma locking_mode that may still be considered: http://
sqlite.org/pragma.html#pragma_locking_mode
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
