Christian Smith
<[EMAIL PROTECTED]> wrote:
Igor Tandetnik uttered:
You want to enable sharing. Pass FILE_SHARE_READ | FILE_SHARE_WRITE
as the third parameter.


Surely not FILE_SHARE_WRITE! You don't want other processes writing
the database while you're copying it.

The file is already opened by another process for read/write, you must specify FILE_SHARE_WRITE otherwise you won't be able to open it. You have to impose a locking mechanism separate from that provided by the OS. Hence BEGIN IMMEDIATE command which guarantees that no writes will occur via SQLite.

Igor Tandetnik

Reply via email to