which values does it have? By definition it should be old values.
On Thu, Sep 10, 2015 at 9:05 AM, Nguyen Dang Quang <quangnd at gmail.com> 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 apply pragma: SYNCHRONOUS = OFF ; > JOURNAL_MODE = MEMORY > > 2. Open a transaction > > 3. Update a row > > 4. Select the updated row in (3) to further processing. > > 5. Loop to (3) until no data to update > > 6. Commit the transation. > > In (4) the selected rows will have old or new values? > > Please help. > > > > > > _______________________________________________ > sqlite-users mailing list > sqlite-users at mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users