Databases
StackOverflow2013
Postsdbo
POHow to make Loader update with sqlite view?
Body
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POHow to make Loader update with sqlite view?
    text
    copied!<p>I got a problem with <strong>LoaderManager</strong>. I have some tables in sqlite database, and also have representation view, which get data from tables.</p> <p>I also had implemented LoaderManager, exactly as in <a href="http://www.androiddesignpatterns.com/2012/07/understanding-loadermanager.html" rel="nofollow">that excellent guide</a> and it works perfectly for table.</p> <p>But I want to update one table, and get updated result not from it, but from sqlite view, related to updated table. In this case LoaderManager, seems, not working (onLoadFinished callback does not fired)</p> <p>My updated table schema:</p> <pre><code> CREATE TABLE [table_scan] ( [_id] INTEGER PRIMARY KEY AUTOINCREMENT, [NR_ID] INTEGER NOT NULL, [T_ID] INTEGER NOT NULL, [Color_ID] INTEGER NOT NULL, [R_ID] INTEGER NOT NULL, [Barcode] TEXT NOT NULL, [NumberSeat] INTEGER, [Date] DATETIME NOT NULL DEFAULT(DATETIME('now', 'localtime')), [Deleted] INTEGER NOT NULL DEFAULT '0', [Status] INTEGER NOT NULL DEFAULT '0', [Export] INTEGER NOT NULL DEFAULT '0'); </code></pre> <p>My sqlite view:</p> <pre><code>CREATE VIEW [view_scan] AS SELECT _id, Barcode, Status, Deleted, NumberSeat, goods_catalog.T_Articul, colors_catalog.Color_Name, sizes_catalog.R_Name FROM table_scan INNER JOIN goods_catalog ON goods_catalog.T_ID = table_scan.T_ID INNER JOIN colors_catalog ON colors_catalog.Color_ID = table_scan.Color_ID INNER JOIN sizes_catalog ON sizes_catalog.R_ID = table_scan.R_ID WHERE Deleted = 0; </code></pre>
 

Querying!

 
Guidance
An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload