Re: [sqlite] Re: Re: Opening the database file for read on Windows XP

2006-06-22 Thread Ran
Actually, I have just realized that I indeed cannot use BEGIN IMMEDIATE to do the locking because it has to be locked from the process that has no SQLite in it... And you already delievered the exact answer of how to do it! Thanks a lot! Ran On 6/22/06, Christian Smith <[EMAIL PROTECTED]>

Re: [sqlite] Re: Re: Opening the database file for read on Windows XP

2006-06-22 Thread Christian Smith
Igor Tandetnik uttered: 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.

[sqlite] Re: Re: Opening the database file for read on Windows XP

2006-06-21 Thread Igor Tandetnik
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