MobileRead Forums - View Single Post - PRS-T1 Recently Opened on Homescreen Hack for T1

Xosen · 09-04-2012, 05:09 AM

Hi pssquirrel,

Thanks for the tips. Of course I had already tried all those options before my previous post. This is the trigger I currently have in both databases (internal and SD):

Code:

CREATE TRIGGER recently_opened_trigger AFTER UPDATE OF reading_time ON books
BEGIN
   UPDATE books SET added_date = reading_time WHERE reading_time NOT NULL AND _id <> new._id;
END;

I have used SQLiteSpy to check it and it's there. Also, when switching between books of the same storage, the update is done correctly, so I know it is launching. What surprises me is that it seems the update is done when opening the next book, or maybe the home display is not updated until you change from one book to another.

09-04-2012, 05:09 AM	#56
Xosen Junior Member Posts: 5 Karma: 10 Join Date: Aug 2012 Device: Sony PRS-T1	Hi pssquirrel, Thanks for the tips. Of course I had already tried all those options before my previous post. This is the trigger I currently have in both databases (internal and SD): Code: CREATE TRIGGER recently_opened_trigger AFTER UPDATE OF reading_time ON books BEGIN UPDATE books SET added_date = reading_time WHERE reading_time NOT NULL AND _id <> new._id; END; I have used SQLiteSpy to check it and it's there. Also, when switching between books of the same storage, the update is done correctly, so I know it is launching. What surprises me is that it seems the update is done when opening the next book, or maybe the home display is not updated until you change from one book to another.