View Single Post
Old 09-12-2012, 10:11 PM   #13
Frescard
Enthusiast
Frescard plays well with othersFrescard plays well with othersFrescard plays well with othersFrescard plays well with othersFrescard plays well with othersFrescard plays well with othersFrescard plays well with othersFrescard plays well with othersFrescard plays well with othersFrescard plays well with othersFrescard plays well with others
 
Posts: 29
Karma: 2910
Join Date: Aug 2012
Location: Montreal, Canada
Device: Sony PRS-T1
What I've done to automatically get rid of the "New" mark is to define a default value for the database cell.
I've set it to 1, so it ends up at the end of the list, but current_timestamp (which inserts today's date, to put it at the top of the list) should work, too.

People tinkering with databases all the time will know what to do—for the rest here are some instructions:
  1. You first need a database utility (I'm using SQLite Expert Personal, which is free).
  2. Hook up the reader to the PC, and set it to "Data Transfer Mode".
  3. Copy the database from [reader]\Sony_Reader\database\books.db to your harddrive (as a backup).
  4. Start the SQL manager, and open that file (the one on the reader) in it.
  5. Select the "books" table (list on left).
  6. Click on the "Design" tab (top of screen, in the middle).
  7. Right-click on the line that has "reading_time" in the "Name" column, and select "Modify".
  8. In the value for "Default" enter a 1, and click "OK".
  9. Click "Apply" (bottom of screen), and close the manager.
  10. Copy a new book to the reader, disconnect it, and try it out..
Attached Thumbnails
Click image for larger version

Name:	readingtime.gif
Views:	125
Size:	141.7 KB
ID:	92273  

Last edited by Frescard; 09-13-2012 at 02:56 PM.
Frescard is offline   Reply With Quote