jeudi 10 septembre 2015

SQLite: update then select the same row in the same transaction

I have a sqlite database and open it with these pargama:

PRAGMA SYNCHRONOUS = OFF
PRAGMA JOURNAL_MODE = MEMORY
PRAGMA TEMP_STORE = MEMORY

Problem is: I have to begin transaction, update some fields in a row then select whole row after that and then commit the transaction. I aware that new updated fields are not reflated changes and it brings me problems. What do I do wrong here? Please help!

Aucun commentaire:

Enregistrer un commentaire