[sqlite] Select after update get new or old values

[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 (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.