View Single Post
Old 07-19-2012, 09:59 AM   #47
pssquirrel
ebooknut
pssquirrel ought to be getting tired of karma fortunes by now.pssquirrel ought to be getting tired of karma fortunes by now.pssquirrel ought to be getting tired of karma fortunes by now.pssquirrel ought to be getting tired of karma fortunes by now.pssquirrel ought to be getting tired of karma fortunes by now.pssquirrel ought to be getting tired of karma fortunes by now.pssquirrel ought to be getting tired of karma fortunes by now.pssquirrel ought to be getting tired of karma fortunes by now.pssquirrel ought to be getting tired of karma fortunes by now.pssquirrel ought to be getting tired of karma fortunes by now.pssquirrel ought to be getting tired of karma fortunes by now.
 
pssquirrel's Avatar
 
Posts: 297
Karma: 688154
Join Date: Oct 2011
Device: Kindle Voyage & Oasis
How to Create "Recently Opened" Trigger on Mac using MesaSQLite

@Snarkophilus: I think you're right that the database is being updated a lot. I'm getting the spinning arrows more than usual, plus for some reason the alphabetization when sorting by filename has gone wonky (it seems to be using "date added" rather than "alphabetical" for some, but not all, books).

I experimented some more -- this is like a puzzle where you know you have all the pieces but you're not sure where to put them. But I think I finally figured out which snippets of code go in which MesaSQLite box. Screenshots attached. So far everything seems to be working properly. Yippee!

Thanks Simon and jackie_w for your help -- and of course, thank you Kolenka for the nice piece of code!
Attached Thumbnails
Click image for larger version

Name:	Create Trigger.png
Views:	599
Size:	58.6 KB
ID:	89391   Click image for larger version

Name:	Resulting Trigger.png
Views:	626
Size:	17.7 KB
ID:	89392  

Last edited by pssquirrel; 07-19-2012 at 02:09 PM. Reason: updated info, including solution
pssquirrel is offline   Reply With Quote