[sqlite] Select after update get new or old values

, 2015 2:02 AM To: General Discussion of SQLite Database Subject: Re: [sqlite] Select after update get new or old values On 10 Sep 2015, at 5:05pm, Nguyen Dang Quang wrote: > In (4) the selected rows will have old or new values? Read this: <https://www.sqlite.org/isolation.html> "W

[sqlite] Select after update get new or old values

Dear all, I am using System.Data.SQLite for my .Net 2.0 application. In the app, I always run a sequence like that: 1. Open connection to sqlite and apply pragma: SYNCHRONOUS = OFF ; JOURNAL_MODE = MEMORY 2. Open a transaction 3. Update a row 4. Select the updated row in

[sqlite] How to unsubcriber this mailing list?

Hi all, By mistake, I joined this mailing list with two email. And now, I don't know how to unsubcriber one. Please help me.

[sqlite] NOT NULL in create table command not work

Hi guys, I used the following command to create table: create table ne(ne_id integer primary key autoincrement, name varchar(50) not null, directory varchar(256) not null, adaptor_name varchar(50) not null, note varchar(500), filter_rule varchar(50), unique(name), unique(directory)) But my