View Single Post
Old 07-20-2012, 10:20 AM   #50
jackie_w
Grand Sorcerer
jackie_w ought to be getting tired of karma fortunes by now.jackie_w ought to be getting tired of karma fortunes by now.jackie_w ought to be getting tired of karma fortunes by now.jackie_w ought to be getting tired of karma fortunes by now.jackie_w ought to be getting tired of karma fortunes by now.jackie_w ought to be getting tired of karma fortunes by now.jackie_w ought to be getting tired of karma fortunes by now.jackie_w ought to be getting tired of karma fortunes by now.jackie_w ought to be getting tired of karma fortunes by now.jackie_w ought to be getting tired of karma fortunes by now.jackie_w ought to be getting tired of karma fortunes by now.
 
Posts: 6,252
Karma: 16544692
Join Date: Sep 2009
Location: UK
Device: ClaraHD, Forma, Libra2, Clara2E, LibraCol, PBTouchHD3
in the absence of JLC, re: the SQLite Manager Firefox add-on, you could try doing it this way:
  1. Open books.db, click on the tab 'Execute SQL',
  2. Copy/paste Kolenka's code into the 'Enter SQL' panel underneath
  3. press the 'Run SQL' button. You should see the new trigger name appear in the left-hand panel after the existing 5 cleanup triggers

The attached image is before the trigger is created, not after.
Attached Thumbnails
Click image for larger version

Name:	sqlitemgr.jpg
Views:	631
Size:	98.2 KB
ID:	89451  
jackie_w is offline   Reply With Quote