[sqlite] Select after update get new or old values

2015-09-11 Thread Simon Slavin
On 11 Sep 2015, at 3:14am, Nguyen Dang Quang wrote: > SYNCHRONOUS = OFF will make new data not visible to select command? "PRAGMA synchronous" is about making sure that the disk (or other storage medium) is updated to reflect changes in the database. Normally changes to files are held in

[sqlite] Select after update get new or old values

2015-09-11 Thread Nguyen Dang Quang
, 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

2015-09-11 Thread Nguyen Dang Quang
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] Select after update get new or old values

2015-09-10 Thread Simon Slavin
On 10 Sep 2015, at 5:05pm, Nguyen Dang Quang wrote: > In (4) the selected rows will have old or new values? Read this: "Within a single database connection X, a SELECT statement always sees all changes to the database that are completed prior to the

[sqlite] Select after update get new or old values

2015-09-10 Thread J Decker
which values does it have? By definition it should be old values. On Thu, Sep 10, 2015 at 9:05 AM, Nguyen Dang Quang wrote: > 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