Android Question ["solved": fake problem ^_^ ] SQLite: Data Change Notification Callbacks

[LucaMs]

If I update a record in a table in a local SQLite db (smartphone) and immediately after I load all of the records, I get the old data.

Can you implement this in any way?

 

[Erel]

If you are using the same SQL object then it should always return the latest data available.

Maybe you are not closing a transaction?

 

[LucaMs]

Yes, I have tried using (and closing) transactions but I get the same result.

 

[LucaMs]

http://developer.android.com/refere...id.database.sqlite.SQLiteTransactionListener)

 

[rboeck]

Hi,

look at this thread;

http://www.b4x.com/android/forum/threads/sqlextended-an-extension-to-the-sql-library.43420/

My problem was opposite - as long i was in the app, the new value came back; but after a new start there was the old value. I switched to writeaheadlogging and it worked. Maybe that there was any defect in the database log file etc.

 

[LucaMs]

Hi,

look at this thread;

http://www.b4x.com/android/forum/threads/sqlextended-an-extension-to-the-sql-library.43420/

My problem was opposite - as long i was in the app, the new value came back; but after a new start there was the old value. I switched to writeaheadlogging and it worked. Maybe that there was any defect in the database log file etc.

Thank you very much, I will read that post.

But I just found out that the problem is elsewhere, in my case, although I still have not solved it!

In a few minutes, I hope.

 

[LucaMs]

Yes, the problem was elsewhere, I'm sorry.


[P.S. related to this]