On Sat, 2 Jul 2011 17:00:57 +0800, "airwolf2026"
<airwolf2...@qq.com> wrote:
> Hi Kees ,
> Thanks for reply,Yes the 'PRAGMA ' is my fault to'program',
> i use the C# wrapper aka "System.Data.Sqlite.dll",When I
> use it to open a sqlite.db,the sqlite openned in the normal
> mode(PRAGMA jounal_mode='Delete', I had downloaded the
> newest version ,my question is current release
> 'System.Data.Sqlite.dll' can support wal mode?
I don't use the wrapper, so I don't know, but the wrapper itself
does. Just feed it the SQL statement:
PRAGMA jounal_mode=WAL;
and then have a look what value
PRAGMA jounal_mode;
returns.
>Thanks
>airwolf2026
>
>
>------------------ Original ------------------
>From: "Kees Nuyt"<k.n...@zonnet.nl>;
>Date: Sat, Jul 2, 2011 04:52 PM
>To: "sqlite-users"<sqlite-users@sqlite.org>;
>
>Subject: Re: [sqlite] current version support wal mode?
>
>
> On Sat, 2 Jul 2011 12:27:07 +0800, "airwolf2026"
><airwolf2...@qq.com> wrote:
>
>>Hello,
>>
>> Can current version support wal mode?
>
>Yes.
>
>> I try this by add
>> "Pragram journal mode = wal;" in connection string;
>> but it doesn't take effect?
>> how can i do that ?
>
>It's not something you do in a connection string, and your
>spelling is not correct.
>
>WAL mode is persistent, once you've set it, the database remembers
>it for all future database connections, so you have to switch it
>on just once, typically immediately after creating the database.
>
>The way to do this is to use SQL:
> PRAGMA jounal_mode=WAL;
>
>http://www.sqlite.org/pragma.html#pragma_journal_mode
>
>THe query parameters SQLite knows do not include journal_mode:
>
>http://www.sqlite.org/uri.html#coreqp
--
( Kees Nuyt
)
c[_]
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
